Access or Excel

Hi Robert

I would recommend Access for this job. the reason is that the querying power in Access is much more powerful that in Excel.

To start, i suggest having the two lists in two separate tables.

The simple way to check for records that do not exist in another table, is to use the NEW QUERY BUTTON in the Query section of the database window. This will allow you to start a wizard for an UNMATCHED QUERY.

Essentially the wizard will ask you to specify two tables, and the fields to compare. It will then build a query that shows you records that do not appear in the other table.
Do this twice, once for each table, compared to the other.

If you then take these two tables and make one table out of them, you should have a list of addresses that DO NOT appear in both.

Let me know how you go.

Regards


Richard
Microsoft OFfice Specialist