query to show all differences between two records?

[martinmike2]

Hello,

I need to have a query that shows differences bewteen records in 2
seperate tables.

The situation is this:

Once a month we update a table with new information obtained from
another source. We delete the last months records out of the history
table and append the "current data" into the history table prior to
the update. We then run several more queries to update, append, and
delete records to and from the "current data" table.

What we need is a report that shows all changes made to the data
during the update. We are referrencing the history table to achieve
this, but I cannot figuer out how to query for differences on ANY of
the fields and not just one of them as the wizrd wants to do.

 

[KARL DEWEY]

Open the query in design view to see the two tables and a line between them
with an arrow. Click on the line then double click on the line. Note the
selection. Close popup window.
Click on the second field you want to compare and drag from table to table
in the direction of the arrow between the tables. It will form a line
without arrow head. Click on the line then double click on the line. Make
the same selection as noted before.
Below the first field in the Criteria row you will see'Is Null'. Do the
same for your second field comparrison but in a separate row.