Query Total

  • Thread starter Thread starter DavidW
  • Start date Start date
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'
 
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.
 
Back
Top