Totals and Subtotals

I'm trying to create a report that counts numbers of records.

E.g., I have records in 4 categories: A, B, C, D

I want a report to look like this:

A 4 records
B 6 records
C 3 records
D 5 records
----------------
18 records total


I've figured out how to get the A,B, C, D part done by using the COUNT
function in the query. But I cannot get the grand total. Every time I try a
=Sum([COUNTID]), I get an error message. How do I get the field that gives
me the grand total.

thanks.

I suspect you want to "count" the CountID field, not "sum" it.

Regards

Jeff Boyce
Office/Access MVP

"aintnorock" wrote in message
...
I'm trying to create a report that counts numbers of records.

E.g., I have records in 4 categories: A, B, C, D

I want a report to look like this:

A 4 records
B 6 records
C 3 records
D 5 records
----------------
18 records total


I've figured out how to get the A,B, C, D part done by using the COUNT
function in the query. But I cannot get the grand total. Every time I
try a
=Sum([COUNTID]), I get an error message. How do I get the field that
gives
me the grand total.

thanks.