Query select on a yes/no field

Singlespeed

Registered User.
Local time
Yesterday, 21:47
Joined
Jun 5, 2009
Messages
33
I am sure this must be easy?

access 2007

I have a table witha checkbox Yes/No field and I want to select just the "yes" or ticks in a query

how can I do this?
 
If you just want to show records in a query where the yes/no field is "yes", then in the critera row for this fileld just put:

True

JR
 

Users who are viewing this thread

Back
Top Bottom