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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete Query: Could not delete from specified tables 0
Using a Yes/No field to trigger a calculation in another field - J 3
IIF Function Within A Query 6
query yes/no field 6
Criteria - show records in text field1 based on a yes/no field2 7
Yes / No query problem 4
IIF Statement in Query 2
Split data in field on character return 0

Top