G
Guest
I have a checkbox in my table. Is the correct criteria in my query for a
checked checkbox "yes"?
checked checkbox "yes"?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
no. use true or false
G
Guest
Thank you. Why is this better since "yes" works?
F
fredg
I have a checkbox in my table. Is the correct criteria in my query for a
checked checkbox "yes"?
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.
M
Mike Schlosser
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
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