DCount Help - Code Inserted

[matthewnsarah07]

I am using the following DCount which works fine until I add the last bit
[QuestionCategoryID] = '1' this throws up a Data Mismatch - [QuestionCategoryID] is a Number field

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

Also in the [QuestionResponse] ='Yes' - this works fine but I want Yes or No - when I add the no it just counts all

Thank for any help

 

[Scooterbug]

Remove the quotes around the 1. When you use quotes, it thinks that it's text.

 

[boblarson]

Take the quotes off of the number 1. You only put quotes if the data is text.