467,144 Members | 1,173 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,144 developers. It's quick & easy.

DCount using Multiple criteria not working

I am using DCount, but I am not able to find how to set simple multiple criteria.
Here is sample of what i need.

Expand|Select|Wrap|Line Numbers
  1. =DCount("PatientProfileID","qryFaceToFaceReason_EAP_VG","FaceToFaceReasonID=2" Or "FaceToFaceReasonID=0")
  2.  
Any help in syntax or formatting would be appreciated.

Note if I just enter ther first criteria it works fine. I was hoping the OR could be used one way or another.

Ken
Dec 3 '07 #1
  • viewed: 4530
Share:
1 Reply
puppydogbuddy
Expert 1GB
I am using DCount, but I am not able to find how to set simple multiple criteria.
Here is sample of what i need.

Expand|Select|Wrap|Line Numbers
  1. =DCount("PatientProfileID","qryFaceToFaceReason_EAP_VG","FaceToFaceReasonID=2" Or "FaceToFaceReasonID=0")
  2.  
Any help in syntax or formatting would be appreciated.

Note if I just enter ther first criteria it works fine. I was hoping the OR could be used one way or another.

Ken
Ken,
Try it this way.

Expand|Select|Wrap|Line Numbers
  1. =DCount("PatientProfileID","qryFaceToFaceReason_EAP_VG","FaceToFaceReasonID= 2 Or FaceToFaceReasonID=0")
  2.  
Dec 3 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Megan | last post: by
1 post views Thread by Chris M. | last post: by
4 posts views Thread by Will | last post: by
3 posts views Thread by BerkshireGuy | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.