excluding records

toddbingham

Registered User.
Local time
Today, 10:32
Joined
Jul 8, 2003
Messages
93
Have a report that is building from a table taht has check boxes for establiching criteria. When I create a report, I want to exclude the ones that have that box checked. How would I do that?
 
Don't base your report on the table. Base it on a query which has all the fields you need. In the query criteria row under the check box field put the word FALSE. Only records without the checkbox ticked will be returned.
 

Users who are viewing this thread

Back
Top Bottom