Table to exclude in Critieria

[Jack W via AccessMonster.com]

Hi,

I have a table that has a list of accounts I want excluded for a query.
Basically, I want this table to be updated by users with any accounts that
should not appear in the query as our information comes from other parties
that include all our accounts.

How can I do this. The query has our account number as a field, now I want my
seperate exclusion table to be a 'not =' criteria. Any ideas?

 

[Dennis]

Add your 'table of accounts to exclude' to your query and join it to the
other table on the account number. Add the account number column from your
excluded accounts table and set the criteria to Is Null

 

[Jack W via AccessMonster.com]

Brilliant, thanks for your help!