Check box criteria in query

[Bryan]

I am having problem getting my query to recognize the
difference between a checked box and an unchecked box on
my form. What do I need to put in the criteria field in
the design form of my query??? Please help!!!

 

[Fredg]

Is the check box bound to a record in the table?
If so...
A Check box field has a value of either -1 (for True, Yes, or On) or 0 (for
False, No, or Off).
So in the criteria for a Check Box field, to indicate a Checked value, you
would write the word
True
or ...
Yes
or ...
-1

To indicate an unchecked value you would write
False
or ...
No
or ...
0

If the Check box is not bound to a field in the table, then you need to use
this syntax:
forms!FormName!CheckBoxName = True (or = False).