I have two tables, table 1 contains 3000 staff records and table 2 contains 300 staff id's.

I need to configure my query so that when it runs the staff records are returned not including the 300 staff id's in table 2.
I thought this would be as straight forward as pointing the criteria to the staff if column in table 2 and using the <> operators. I've tried this but it does not work.

A point in the right direction would be appreciated.

Running the default "unmatched" wizard should do the trick for you.

Thank you, I cannee believe it was so simple!:o

well something are just... that simple :)