SubTotal Count

[Guest]

I have created a crosstab query that groups by school as the row heading and
groups by grade as the column heading. There is also a grouping by homeroom
and a count of student_id. The end result is the number of students in each
homeroom, in each grade in each school. I also need to get a total of
students in each grade by school, as well as the total number of students in
the school but can't figure out how to add together the count of field.
Result should look like:

GR01 GR02 GR03
SchoolA
10 15 18
12 14
Total: 22 29 18 69
SchoolB

Any suggestions would be appreciated.

 

[Tom Ellison]

Dear Silve:

I suggest you either do this in a report (which will do sums rather easily)
or get ready to create the UNION of 3 queries, which is going to get fairly
complex.

Tom Ellison