Excluding certain records in a report

[bluke]

I created a report where is lists sales volume by day. I was asked to create a table where data can be excluded from this report. The exclusion table consists of only three fields:

Date Department and a check box

What do I need to do in the report (or the source query) to have it exclude the data listed in this exclusion table. The table only holds data we want excluded, not all dates and departments.

I originally added the table to the source query and made the criteria "False" for the check box but when the query runs it does return any data at all.

Please help!

 

[oldaf294]

bluke,
try
0 for false
or
-1 for true
Do not use quotes as it is a boolean field

 

[labbadabba]

I will usually build an expression in the query that is based on an IIf statement. i.e. IIf([Field1]>0,"x","") and that will give me something to sort with. I'll build another query off of that and put "x" in the criteria so that all the records I don't want are excluded. I then build my report of that query.