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
 
Back
Top