Comparing Data tables

[kmrowlan]

I have two tables that I want to compare data. Table1 and table2
The field names are equal.
Table 1 has the most current information. In this table, some of the data in the existing records have changed and some records have been added.

I want to compare the two and capture the data changes and identify the new records that have been added.

I tried to do a join properties in a query, but when I do, it does not pick up the added records. What should I do here?

 

[boblarson]

For your join you would want an OUTER JOIN from Table 1 to Table 2. Double click on the link between the two and then select either option 2 or 3 whichever says something like:

Select all records from Table 1 and only those records that match from Table 2.