creating a query based on a yes/no field

N

nergdergler

Hi, I have a table with two yes/no fields. I want a query
that returns data based on one of the yes/no fields being
yes.
 
C

Cheryl Fischer

The values stored in a Yes/No field are: -1 (for Yes) and 0 (for No)
So, if you want your query to return records where SomeField = Yes, just put
a -1 in the Criteria: row for SomeField
 
Top