Display # records at bottom of report.

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

I'd like to display the total number of records when the
report is executed. What is the best way to retrieve this
and then display it at the bottom of the report.

Thanks,

Dave
 
-----Original Message-----
I'd like to display the total number of records when the
report is executed. What is the best way to retrieve this
and then display it at the bottom of the report.

Thanks,

Dave
.
In the report footer, create a text box. On the Data tab
Click to expand...
of the text box, set the control souce to "=Count(col)"
where col is the name of a column on the report.
 
Back
Top