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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Julia Smith - 02 Jul 2006 11:28 GMT

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!

Reply to this Message

Douglas J. Steele - 02 Jul 2006 12:02 GMT

Easiest approach would be to use the DCount function:

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

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

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

Reply to this Message