N nergdergler Apr 27, 2004 #1 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.
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 Apr 27, 2004 #2 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
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
