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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

display a total value 4
counting records 0
Record count in report w/o records 9
A03 - count in report footer gives me #Error? 0
Report Returned Record Count 2
filter report based on calculated field 1
Record omission 2
Access Counting records based on multiple age bracket and output to tabulated report 0

Back
Top