How can I compare data in tables?

D

David

I need to detect (by record) any difference in the data in two tables that
have identical formats.
I can write a query to do it one field at a time but I want every field for
every record.
How?
 
D

DevalilaJohn

Try this, set up your query to sort however you need and establish your
relationship(s). For each field pair you want to compare create an
expression:
CheckFld1: IIf(tbla.fld1 = tblb.fld1, 0,1)

Then set the criteria on this expression to = 1

Depending on your requirements, you can include the actual fields too. Once
you produce this query, you have what you need to start doing a report(s) on
what's different. Keep in mind that all the fields for a record with any
difference will appear, so you may need to filter more based on your
requirements.
 
Top