DCount with multiple criteria?

  • Thread starter Thread starter Guest
  • Start date Start date
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!
 
Try this

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