Comparing tables

R

RA

I collect reports weekly from an automated system. I save the reports as
individual tables in Access. All of the fields are identically names. I
need a query that will look through the newest table and comparer it to the
prior table (I know that part may be manual) and show only the items that
changed, old value and new value (and the additions or deletions in a single
query would be nice)
 
R

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;
 
Top