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