Totals and Subtotals

[aintnorock]

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.

 

[Jeff Boyce]

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

Regards

Jeff Boyce
<Office/Access MVP>