Number of records in a query.

  • Thread starter Thread starter Ayo
  • Start date Start date
Try:
DCount("*"), "Query1")

Substitute your query name for Query1.
 
or if you're using SQL Server SELECT @@ROWCOUNT right?

THanks

-Aaron
 
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
Special characters 3
How can I limit the number of records in a table, not a query? 4
Running Query In VBA, Bypassing Warnings? 7
Read query records 3
Access Print Files from Query Results 0
Count in a query 2
Controlling the number of records displayed. 5

Back
Top