Compare record data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unmatched data 3
Identifying Duplicate Records 8
Comparing records in tables 2
Lookup current record with ComboBox, any changes create new record 3
Excel Comparing two columns 1
Compare data that do not exactly match 3
Open form at first Alpha not first record number key 5
Compare table for changed data 1

Back
Top