Query only records with checked box

  • Thread starter Thread starter Thorson
  • Start date Start date
T

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
 
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)
 
Back
Top