Footer coding of record count

C

ctdak

I have a report for which I am setting the RecordSource programmatically when
it opens. I would also like to programmatically count the number of records
that print on this report and place that in a footer control.

I have to do this programatically because the RecordSource table can vary,
and therefore fields assigned to controls in the detail section of the report
can also vary.
 
D

Duane Hookom

Add a control to the Report Footer section with a control source of:
=Count(*)
 
C

ctdak

Thanks. That worked. I didn't know about using "*" as the argument. I
thought I would have to do this in code somehow.
ctdak
 
Top