Total number of records in report

[ngs88]

On my data base I produce a report which gives a list of records based upon a query. How can I get it to print the number of records displayed at the footer

 

[Rich]

=Count(*) as the control source of an unbound textbox

 

[ngs88]

Tried =Count(*) in an unbound text box in the report footer but it returns error

 

[pbaldy]

Are you sure it's in the report footer rather than the page footer? It will error in the page footer.

 

[ngs88]

Well done Paul that did it thanks