Query: Criteria: Checkbox?

C

Confused87

I have a check box and I need in a query to list results for the boxes which
are ticked. - What do I need to write in the criteria?

Thanks
 
G

golfinray

Checks are stored as a -1, unchecked as zero. So, Like -1 will tell you the
number checked.
 
J

John W. Vinson

Checks are stored as a -1, unchecked as zero. So, Like -1 will tell you the
number checked.
Click to expand...

Actually one should NOT use the LIKE operator in this context. LIKE is used
for only one purpose - searching text fields with wildcards. If you're not
using wildcards, it is identical to the = operator and (in the criteria line)
should simply be omitted.
 
Top