Hi all,

First off... Thanks in advance

No onto my problem

I'm doing a data integrity check and need a little help. I have a table with manager logins and a table with old company IDs and new company IDs.

The manager login can be either their old company ID or their new company ID. I need to query the manager logins against both the new and old company IDs spit out a list of manager logins that are not either the new or old company ID, thus giving me the manager logins that need to be removed from the system.

The only way I've managed to accomplish this so far in Access 2007 is to run a query on the manager logins against the old IDs and save it, then run a query on the manager logins against new IDs and save it, then run a third query on the two newly created queries looking for anything that is null in both tables.

I'm hoping to find a quicker way to do this short of writing some SQL code.

Thoughts?