Counting records

  • Thread starter Thread starter John
  • Start date Start date
J

John

Hello

Is there a function which counts the number of records
which meet a particular criteria within a query?

Thanks
 
Hi,


DCount( "*", "SavedQueryOrTable", "criteria here")



Hoping it may help,
Vanderghast, Access MVP
 

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
Query Question 3
counting Null fields 3
Access Counting records based on multiple age bracket and output to tabulated report 0
Sum of Counts from a query 1
'Data type mismatch in criteria expression' error in Count query 2
'Data type mismatch in criteria expression' error in Count query 1
The "count" function 3

Back
Top