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

J

Julia Smith

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!
 
D

Douglas J. Steele

Easiest approach would be to use the DCount function:

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