checked or unchecked?

[Pauly78]

Hi,

Im trying to run a query to show results based on if an item has a certain value in one field, it works fine, but then i also want to select if an item has a value i another field, its a yes/no value which is a checkbox, could anyone tell me what i need to insert into the query criteria field if i want the result to only show if its unchecked?

Thanks

 

[pbaldy]

Any of these should work:

0
False
No

 

[Pauly78]

Ive tried all of these and i get a data type mismatch in criteria expression error

 

[pbaldy]

Are you sure it's a yes/no field? Can you post the db here?

 

[Pauly78]

I choose a yes no field, the one which you place a check in the box for yes or leave for no. However, to solve my problem I changed it to short text I have a table with yes or no so used a combo box and used this as the value and it works fine. Thanks.