I want to display a record count in a query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to see a field showing the number of records returned in my
query, how can I do that?
 
Create a "Totals" query and "count" the number of records "grouped by" some
other field.
-Ed
 
Can you post the SQL text of your current query? And can you explain why you
need to do this? And where - in a form, in a report, ...?

You may be able to use DCOUNT to do what you want in a query.
On a form, you might use RecordSetClone.RecordCount
In a report, you might use =Count(*) as a control's source in the report header
or footer.
 
You must log in or register to reply here.

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

Access Dcount (multiple criteria) 3
I want to display a record count in a query 1
Unique values in two fields in query 1
Access Counting records based on multiple age bracket and output to tabulated report 0
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Count number of records for a policy 4
Selecting the last 10 records from a specific date 2
Query design 0

Back
Top