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

Best phone camera 2017

Stunning new film posters by Hattie Stewart, Joe Cruz & more

iPad Pro 10.5in (2017) review

28 astuces pour profiter au mieux de votre iPhone