Unmatched query

[RA]

I have access to a Cisco ICM database. Whenever I make changes to the ICM
system, it updates the tables. To monitor the changes and to keep track of
the old information, I pull a report and save it in an Access database as a
new table, each report carries a table name by the date of the report. I
need to know how to pull a report that looks at two of these tables and
display all of the records where the information has changed. The standard
"Unmatched" query only pulls the records where the data is missing form the
newest report.

Often the changes may be small, ID 1234 was assigned to route 5678 now
assigned to 2341. SInce the valus isn't null, the new value isn't
identified. Any ideas?

 

[RA]

Maybe I'm asking the question the wrong way:

I want the query to return only the value that are different and I want to
see the old value (tble1) and the new value(tble2).

 

[RA]

I found it:

SELECT [Cisco 7-29].EnterpriseName, [Cisco Very Old].EnterpriseName
FROM [Cisco 7-29] INNER JOIN [Cisco Very Old] ON [Cisco 7-29].RouteID =
[Cisco Very Old].RouteID
WHERE [Cisco 7-29].EnterpriseName<> [Cisco Very Old].EnterpriseName;