access guru reqd

  widdy 15:57 02 Sep 08
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 08

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.

Sniper Elite 4 review: Headshotting Nazis has never felt so good

1995-2015: How technology has changed the world in 20 years

The Fresh New Fonts of 2017

WWDC 2017 dates: How to get WWDC 2017 tickets, when is WWDC 2017 and more details announced