Totals and subtotals

  • Thread starter Thread starter wthoffman
  • Start date Start date
W

wthoffman

I want to total dollars sales by each person. I have sorted the sales person
in ascending order and the sales need to be totaled by each sales person and
then a grand total. I have 2007 access and the query only has two fields in
it.
Thank you
 
With the query in design view, to up to the View menu and select Totals.

Make sure that the sales person field says Group By and the sales column
says Sum.

For a grand total you'll need to use this query as the record source for a
report. Then let the report do the grand total.

If you are using Access 2007 the above instructions aren't quite right, plus
you can do a grand total in the query without a report.
 
You say you want 'Totals and subtotals' but with only two fields. If the
total in on sales person what is the subtotal on?
 
Back
Top