difference between two tables 1

[bartsimpson]

I have two access tables, where the structure in each is exactly the same. They were taken from the same database, one a month later than the other.

There are some records that have been deleted - I can use the "Find unmatched query" wizard to find them, no problem. Some data was changed in the tables during the month, though. How do I find which records have data that is changed ? The structure of each table is as follows :

ID
Text1
Text2

Only the data in Text1 or Text 2 will have changed.

 

[PHV]

SELECT *
FROM Table1 INNER JOIN Table2 ON Table1.ID = Table2.ID
WHERE Table1.Text1<>Table2.Text1 OR Table1.Text2<>Table2.Text2

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[bartsimpson]

Just what I needed - thanks