Number of records in a query

  • Thread starter Thread starter Keren Kapach
  • Start date Start date
K

Keren Kapach

Hi,
How can I get the number of records in a query result?


Thanks,
Keren
 
Use the DCount() function.

DCount("*", "YourQueryName")

returns the number of "rows" returned by your Query.
Alternatively, you can change your Query to a Totals Query.

HTH
Van T. Dinh
MVP (Access)
 
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

Query Parameter using multiple options 0
How does one eliminate blank records on a query result? 3
Database Import Duplicate Issue 0
Access Dcount (multiple criteria) 3
How can I limit Access query to 65000 records 4
How can I limit the number of records in a table, not a query? 4
How do I set up email account? 1
query 4

Back
Top