Grand Total in a Query

M

Mike

I have a table with two fields Class Type and Number Of Students.
I have a query that totals the Number of Students by Class but how do I get
a grand total of the Number of Students for all Classes?

I have searched the help blogs but unable to locate a good example.

Thanks,
 
D

Duane Hookom

You do this in a report or form footer. If you think you really need it in a
query, you can probably combine multiple queries in a union query to get more
than one level of totals.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The next Grand Theft Auto title has been officially announced 0
pass parameter value to query 1
SQL query with Many-To-Many relationship??? 2
An Unmatched Query? 2
Grand Total Problem 2
ROUNDING A "GRAND TOTAL" 1
Create a Not In query, but show only certain records 3
Excel Need Countifs Formula Help 0

Top