syntax to filter a report on a check box

G

Guest

I am a rusty user of Access - have created a basic table which includes a
check box - I have a done a report which I just want to include those where
the checkbox is ticked (or of course exclude those that are not) and do a
similar report for those that have not been ticked. I cannot get the syntax
to work as it is not numeric, nor is it text ie "yes" or "no" - and I cannot
find anything about the checkbox for filtering in the Help - Your help would
be much appreciated. Thank you
 
V

Van T. Dinh

Try True (ticked) and False (unticked).

Note also True = -1 and False = 0 so you can even try -1 / 0 (but True and
False are easier to read).
 

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

What is the syntax to filter on a check box? 1
Check boxes on querys 1
Query linked to a check box? 2
Filter query with checkboxes 0
Syntax problem for text criteria to filter a report 8
Check box teaser 2
Check Box to control Text Box 4
Query criteria based on a Check box 8

Top