access guru reqd

  widdy 15:57 02 Sep 2008
Locked

Running a query in Microsoft Access produces the following table however I would like Access to Add a Total to the right of each person (orders + pre-insepctions), also at the bottom to give me a total of all Orders and All Pre-inspections.

Can anyone help ?

Operator Name Orders Pre-Inspections
dwestwood 70 1
hibbott 90 5
jbaker 1 0
jmills 16 0
lgodward 124 1
mgriffith 90 6
mparker 48 3
santrim 52 3
slock 90 4
sodoherty 130 10

  Chris the Ancient 16:09 02 Sep 2008

Ideal site for help with Access.

click here

You need to register - bit it is free.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Dell XPS 13 9370 (2018) review

Creative studio Omnibus' brand identity for We Said Enough fights back against sexual misconduct

WWDC history: Apple's product launches since 2005

Espace de stockage : comment libérer de la mémoire sur votre iPhone ?