sql code brings a type mismatch any suggestions?

[jimbo62]

I have a form that takes input from many fields and modifies the underlying query. I have this code for selecting a criteria based on a check box value.

This statement brings back a "Type mismatch" all fields are text ...

If (Me![ChkNODY]) = True And (Me![ChkNODN]) = True And (Me![chkNODX]) = False Then
sWhere = sWhere & " and qryEx_CauseByNOD.[NOD] = '" & "Y" Or "N" & "'"
End If
it runs ok for one value if i take out the or "N"
I want to be able to use an or statement to get 2 values returned.

It has to be simple I must be missing somethingsmall.

Any Suggestions???

Thanks Jim

 

[VBslammer]

You have to include the argument for each case:

" AND qryEx_CauseByNOD.[NOD] = 'Y' OR qryEx_CauseByNOD.[NOD] = 'N'"

VBSlammer

Unemployed in Houston, Texas