How do I count the number of records that meet specific criteria?

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

Guest

I want to be able to count the number of records for specific criteria - i.e.
how many records were submitted by a specific person over a specific time
period. I would like to be able to display this count number in a query or
report. I'm quite new to access and learning as I go along!
 
Easiest approach would be to use the DCount function:

DCount("*", "MyTable", "UserId = 'xyz' AND " & _
"TransactionDate BETWEEN #06/01/2006# AND #06/15/2006#)
 

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

Back
Top