Querey criteria when you are using check boxes

[Hope Valley]

I want to make a query and the field had check boxes. I want only the checed boxes in the field, not the unchecked boxes. What do I put in the criteria to get this

[zmbd]

Hope Valley,
Start out with the query wizard. It does a fairly good job creating the basic "Select" query.

Once you have that created and saved you can then open the query in design mode.
In the grid section will be your fields.
Under the field with the name of interest, say [CheckMe], there will be a row titled criteria... all entries on the same road are "And" logic, all entries on separate criteria are "or" logic.
Now, under the field, in the criteria row, enter. True, or Yes, or 1, or -1...
Save
Run
only the fields with the check mark will return

( MS Support: Examples of query criteria )


You might find the following interesting:
Allen Browne: Why I stopped using Yes/No fields