Yes/No Fields in Query

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
 
C

Cathi Payne

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
 
Top