Totals and Subtotals

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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>
 
Back
Top