How can I compare data in tables?

  • Thread starter Thread starter David
  • Start date Start date
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?
 
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.
 
Back
Top