Compare record data

K

Ken

Does anyone know of a way (perhaps even a third-party utility) that would
compare the contents of two tables and identify any records whose data has
changed?

I'm not talking about using an unmatched records query.

For example, let's say I have two identical tables: tbl_A and tbl_B. Let's
say that both tables have the same 100 customers. However, the address for
customer ABC is different in each table. Is there any way that this could be
identified?

It would be great if there was a VBA solution. However, I don't mind
calling a third-party utility from my form.

Thanks in advance!
 
B

Barry Gilbert

I think you could do it with a query. Create a one-to-one relationship
between the field(s) you want to compare. Then, in the criteria for the field
in one of the tables (table1), put:
<> Table2.FieldName

This would returnm a list of records where that column's data doesn't match.

Barry
 
Top