DCount with multiple criteria?

G

Guest

Again, I've searched the groups and can't seem to find an answer:

I am trying to count the number of records in a table for a report.

I work in a blood draw room and would like to be able to see the number of
patients ([SSN]) a phlebotomist ([PhlebName]) sees on a particular day
([DrawDate]).

Right now I have a DCount function as follows:

=DCount("[SSN]","[PatientData]","[PhlebName]='Smith, John'" AND "[DrawDate]=
#12/21/2005#")

Unfortunately it seems that this function takes either argument. Can
someone point out what I'm doing wrong.

Thanks in advance!
 
G

Guest

Try this

=DCount("*","[PatientData]","[PhlebName]='Smith, John' AND [DrawDate]=
#12/21/2005#")
 

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
Find all records for a specific month 1
Use a form to populate a report 5
Count If or DCount -SLOW!! 3
DCount with mathematical criteria, DateDiff function 2
DCount with Multiple Criteria 2
DCount with Date criteria 2
DCOUNT function works when rpt uses 1 query; but NOT another?!?!? 8

Top