Check Boxes

A

Asa Kaplan

I am using a check box to identify information in a
report. What criteria do I use in a query to show only
items with checks in the check boxes?

One suggestion that I received was:

WHERE
.[yes/no column]=True

When I used this every record was shown. When I
used "=No", no records were shown. Is there a way to
show only records with checks in the check boxes?
 
D

Duane Hookom

True should work in the criteria. You could also try
-1
which is the same as true.
 
Top