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

  • Thread starter Thread starter Charlie
  • Start date Start date
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..
 
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(*)
 
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.
 
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.
 
Back
Top