Quick DCount Question

[matthewnsarah07]

Hi

Quick one

in a DCount criteria expression I want to count one field if it contains a Yes or No answer - its a text field not a Yes/No

I was trying [QuestionResponse] = 'Yes' or 'No'")

Any help on what I'm doing wrong

 

[boblarson]

You would need to use:

"[QuestionResponse] = 'Yes' or [QuestionResponse] = 'No'")

 

[matthewnsarah07]

Many thanks thats sorted it

 

[matthewnsarah07]

Apologies should have mentioned there are multiple criteria as below, adding the or just bypasses the other criteria - what can i do?

Me.CH = DCount("ResponseID", "tblResponses", "[StaffID]=[TOID] And [CheckPeriod]= [CheckPeriod] And [QuestionCategoryID]= 1 And [QuestionResponse]= 'Yes' or [QuestionResponse]= 'No' ")

 

[boblarson]

Add parentheses:

Me.CH = DCount("ResponseID", "tblResponses", "[StaffID]=[TOID] And [CheckPeriod]= [CheckPeriod] And [QuestionCategoryID]= 1 And ([QuestionResponse]= 'Yes' or [QuestionResponse]= 'No' "))

 

[matthewnsarah07]

Thanks Again!