Querying on yes/no field check box?

  • Thread starter Thread starter Cynthia
  • Start date Start date
C

Cynthia

This must be simple - but I cannot find any instructions
anywhere on using a yes/no field (which shows up as a
check box in the form) as criteria in a query - what I am
trying to do is find all records where the check box is
NOT checked. Is Null doesn't work, nor does = No
(assuming that a non-checked box is counted as No).
Suggestions would be most welcome!
 
Have you tried using the If function, ie., If
CHECKBOX.CHECKED = False, then do something? Or your
parameter would be "FALSE" rather than "Yes" or "No"?
 
This must be simple - but I cannot find any instructions
anywhere on using a yes/no field (which shows up as a
check box in the form) as criteria in a query - what I am
trying to do is find all records where the check box is
NOT checked. Is Null doesn't work, nor does = No
(assuming that a non-checked box is counted as No).
Suggestions would be most welcome!
Click to expand...

On the Check Box field criteria line write:
0

No or False (without quotes) should also work.

If you still have difficulty, copy and paste the entire query SQL into
a message and post it back in this same thread.
 
Back
Top