total records in a report

agorman

Registered User.
Local time
Yesterday, 16:51
Joined
Dec 30, 2006
Messages
68
Is there a way I can add at the base of a report, the number of records in a table?

Thanks

Adrian
 
Hi Adrian,

Not that good on report and there may be a better way of doing but this works for me.
Add a text box into the detail section of the report call it "recordcount"
Control source =count([fieldtocount])
'Replace fieldtocount with the name of a field in your report.

Add a text box into the Page footer section of the report
Control source = [Recordcount]

Once you have checked it you can set the "recordcount" Visible to no

Garry
 
Thanks Garry - that is perfect !

Regards

Adrian
 

Users who are viewing this thread

Back
Top Bottom