Counting the number of records in a report

B

Beth Boughan

I would like to count the number of records within a report, but cannot seem
to determine the correct formula. I envision the "Count" field being placed
in the footer of the report and automatically totaling the number of records
within the report. However, I don't know if an underlying paramater query
will cause a problem with running the count function.
 
D

Dirk Goldgar

Beth Boughan said:
I would like to count the number of records within a report, but
cannot seem to determine the correct formula. I envision the "Count"
field being placed in the footer of the report and automatically
totaling the number of records within the report. However, I don't
know if an underlying paramater query will cause a problem with
running the count function.
Click to expand...

What have you tried? Normally, a text box with the controlsource

=Count(*)

placed in the report footer section (not the page footer section) will
do the trick. Or you can add some explanatory text to the
controlsource, like this:

="A total of " & Count(*) & " records were included in this report."
 
F

fredg

I would like to count the number of records within a report, but cannot seem
to determine the correct formula. I envision the "Count" field being placed
in the footer of the report and automatically totaling the number of records
within the report. However, I don't know if an underlying paramater query
will cause a problem with running the count function.
Click to expand...

=Count(*) in the Report Footer will return the number of records in
the report.

= Count(*) in a Group Header/Footer will return the number of records
in that group.
 
Top