How do I create query criteria based on a check box?

[Guest]

The database contains a 'yes/no' check box. I want to create a query that
will return only those records for which the box is not checked. I can't
find any related information on the Microsoft website.

 

[Guest]

Dew,

In the criteria box type the word False. This will return only those
boxes that are not check. If you want to return those that are check type
the word True in the criteria box.

Hope this helps.

SFCA

 

[Douglas J. Steele]

While it may be called a Yes/No field in Access, it actually stores True or
False.

When you're building the query, put False for the criteria for the field in
question.