Counting the number of records in a report by group, then overall total

C

Charlie

I am having trouble with getting my report to subtotal
each group by counting the records. I have it based on my
date field, but there are duplicate dates and it only
counts them as 1 record, which throws my numbers off.
Should I not base my count on any certain field?
Confused..
 
D

Duane Hookom

I would expect that you have a date field as your sorting and grouping
expression and have displayed either the header or the footer. You should be
able to add a text box in the header or footer with a control source of:
=Count(*)
 
C

Charlie

Thanks for getting back with me so quickly. I do have a
date field, but there are duplicate dates, so it just
counts that as 1 record when there might be 3 or 4 or more
with the same date.
 
D

Duane Hookom

If you have 25 records in your report's record source then the expression
that I suggested will place 25 in the report footer. This has never failed
to work correctly for me (or others). Check your report's record source for
an accurate count.
 

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

Counting records in group not working - Access 2007/WinXP 4
Count total number of groups in report 4
How do I not count duplicate records in a report 1
Running total by group 1
Report for Counting orders keyed 1
trying to sum a group of records but "sum" missing from Group, Sort, and Total dropdown/wizard 8
Total Headache 2
Help me count records without duplicates 3

Top