Query to Difference Two Databases

[Guest]

I need to generate a report that lists all the differences found in the
records of two databases. One database is a duplicate of the other, but in
another location that is physically separate. I won't go into why...it's a
long story. I just want to be able to list any records (with the same ID)
for which differences exist in identical fields, and then list the "before"
and "after" values for any of the fields for that record that are different.

For example:

ID = 1391
Field = "First Name" Before = "John" After = "George"
Field = "Last Name" Before = "Doe" After = "Strait"

Format, etc don't matter right now - I just want to be able to gather the
data first!

Any hints would be appreciated.

Thanks,

Eric

 

[kingston via AccessMonster.com]

Create a query with both tables in the input section and link the records via
the ID. Output matching fields from both tables with criteria <>[Other Table]
[Field]. This should get you the data you want. You should be able to
create a report from this data set easily. hth