Yes/No Fields in Query

  • Thread starter Thread starter Denise
  • Start date Start date
D

Denise

I have over 50 Yes/No fields in a query and I want only
the ones that are checked off Yes to show up in the report.

How do I pull only those in the query?

Thanks,
Denise
 
Apply the criteria -1 which is the numeric value for Yes to the query and the query will only give you those records that are yes.
Cathi Payne
 
You must log in or register to reply here.

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

Counting up Yes/No fields in queries 3
counting yes/no fields 3
Yes / No query problem 4
query yes/no field 6
How do I set criteria to show only Yes cases using a Y/N field? 2
Multiple Yes/No fields + IIF 2
IIF Statement in Query 2
yes/no field in query 4

Back
Top