Display # records at bottom of report.

[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

 

[Wayne Zywiec]

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

of the text box, set the control souce to "=Count(col)"
where col is the name of a column on the report.