Hello I'm trying to do a dcount in a Query where a boolean, Yes/No field is set to true but I keep geting the msg. Data type mismatch in critiria expression
here in the count
If DCount("[ID]", "Survey_Query", "[Do_Survey] = 'True') < DLookup("[Min_Survey]", "Corporate") Then
I have tryed
'" & "True" & "'" ""True""" '" & True & "'" as well all returning the same issue I must be missing something
TIA