What do I enter in Criteria to query yes/no checked boxes?

G

Guest

I have a database set up with yes/no data. The data is displayed as
checked/unchecked boxes. I want to run queries that will return only those
records that have checked boxes. What do I insert into the Criteria field to
return those records? I tried ="Yes" and =1, but both returned no records.
Does anyone have any ideas or suggestions?

Thanks
 

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

Expression for Criteria for Form with Combo Boxes 1
Check Box query help 2
Using IIF In Query Criteria 4
Count Yes/No with Criteria 2
Query Help - How to total checked boxes? 2
Retrieving records where yes/no data type is checked 8
Yes/No query from form. 1
Filter yes/no field 2

Top