Excluding Records from separate table

[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 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!

 

[wazz]

you shouldn't have to create a new table to exclude data from a report but, instead, use a query to filter the existing data in the existing table.

it's really hard to tell what you need. do you want to exclude certain fields or certain rows of data? if it's fields then don't add them to the query. something more specific?

p.s. can you plz delete the duplicate post of this thread.