View Full Version : excluding records


toddbingham
08-20-2003, 06:37 AM
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?

AncientOne
08-20-2003, 07:12 AM
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.