Query: Criteria: Checkbox?

  • Thread starter Thread starter Confused87
  • Start date Start date
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
 
Checks are stored as a -1, unchecked as zero. So, Like -1 will tell you the
number checked.
 
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.
 
Back
Top