Criteria for Checkbox

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a checkbox in my table. Is the correct criteria in my query for a
checked checkbox "yes"?
 
I have a checkbox in my table. Is the correct criteria in my query for a
checked checkbox "yes"?
Click to expand...

A check box has a value of either Yes, True, On, or -1 for a checked
checkbox, and No, False, Off, or 0 for an unchecked checkbox.
Notice that there are no quote marks around any of the values.
They represent numbers, not text.
 
Yes, True, -1
No, False, 0

All work. No quotes.

Be carfull clicking around in an open table with checkboxes.
Just clicking in the checkbox cell will toggle the value, unlike clicking
into a text or number type cell.

Mike Schlosser
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Checkboxes and Query Criteria 1
Filter query with checkboxes 0
question driven query 6
Setting Criteria in Query 1
Checkboxes Option Group Questions 1
Using IN() with IIF in criteria 3
Using IN() with IIF in criteria 2
Query with more than 8 'OR' criteria? 2

Back
Top