Access 2003: Finding differences in two tables

[Steve F]

I have two tables of names and addresses. The layout of both is the same
(they came from the same customer, but at different times), and they look
visually to be very similar. I would like to find out exactly how similar
they are.

Using First Name, Last Name, Street & ZIP code as the “matching†columns, is
it possible to construct a query that will show which rows are different
between the two tables? I don’t care about the rows that are the same, I
want to see the information from both tables when they are different, and
determine whether or not to change the data in one of them.

MS Access’ “Find Unmatched†query wizard doesn’t really come anywhere near
producing the result I’m looking for.

TIA,
Steve

 

[Sylvain Lafontaine]

You should explain what you mean by "different". Does this mean that the
fields First Name, Last Name, Street and Zip code must be identical but that
there are other fields which are different or does this mean that some of
these four fields would be either identical or different? The first
possibility is easy but the second is more difficult to solve.

Also, this newsgroup is about Access ADP (.ADP files) and SQL-Server and has
nothing to do with the SQL query language of standard Access JET database
(.MDB or .ACCDB database files).

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam please)
Independent consultant and remote programming for Access and SQL-Server
(French)