Query only records with checked box

[Thorson]

I have a table I would like to query, but I want it to only query the records
that have a check in the check box. What do I put in the "Criteria" line to
limit the query?

Thanks

 

[golfinray]

Since checkboxes return a -1 for yes and a 0 for no:
IIF([yourfield]=0,"no","yes")

 

[Jerry Whittle]

The word Yes without quotation marks will work. Also the number -1 (minus 1
without the quotation marks).

No and 0 will return those without a check mark.

FYI: You can sum up all the Yes values which will give you a count of the
Yes's but as a negative number. The ABS function will turn in into a positive
number like so:

YesCount: ABS(TheYesNoField)

 

[Duane Hookom]

The criteria under the field/column can be
-1
or
True
or
<>0