Query Total

D

DavidW

I have got a query too sort a field from a table by the current month, how
do you total all of the entries that exist in the query for that field to
get a grand total of gallons used?
tbl name 'usage'
query name 'gallonsused'
 
S

Steven M. Britton

You can right click to bring of the Total option, then
have it Count or Sum the gallons used, which ever it is
your looking for. Just make the date field NOT SHOW by
unchecking the box.
 
Top