Just display record count

  • Thread starter Thread starter Alex
  • Start date Start date
A

Alex

Hi I have a report based on a query. All I want to do is onthe report,
display the total number of records within the query. Can someone tell me
how to do this please - I cant seem to get it right.

Thanks

Alex
 
If the records are listed in the report, you could just add a text box to
the Report Footer section, and set its Control Source to:
=Count("*")

If the query is not related to the report, set the Control Source to:
=DSum("*", "Query1")
where "Query1" represents the name of your query.
 
Back
Top