paramater query problem

[tizwaz]

I have a simple query with a yes or no field. when I type yes or no in the criteria it returns the data correctly. However when i put a paramater in ie [enter yes or no] and then type either yes or no I get an error saying it is incorrect or too complex to evaluate.

Actually I would like to be able to type yes, no or leave blank. Can anyone tell me how to do this?

 

[ZmrAbdulla]

What Data Type is that field? If Yes/No then
Try True or False instead of Yes or No

________________________________________________________
Zameer Abdulla
Help to find Missing people
Do not cut down the tree that gives you shade.

 

[tizwaz]

Data type is yes/no. The query works if I type yes or no or true or false but when I try and type either in the paramater box it gives the error

 

[tizwaz]

I've tried
IIf([enter yes or no]="yes",-1,0)
which works if I type yes or no in the paramater. Now all I need is to return all records if the paramater box is left blank

 

[tizwaz]

Its ok I've answered my own question
IIf([enter yes or no or leave blank for all]="yes",-1,0) Or Like [enter yes or no or leave blank for all] Is Null

seems to work