need to compare two tables

[ZeroWard]

So I have data imported into two different tables from two monthly inventories.

The information listed is:
Publication name
Revision number
Stock number
Publication date
Status
EDD
Subaccount
Distribution date
Subscribed


On hand

I would like to run the newest months table against the last table to see what has changed, is there any way to make a query check for variations in all of those fields instead of just one?

Thanks!

[JoeM]

One way is to an an unmatched query on EVERY field.
You can do this by running the Unmatched Query Wizard. This will only allow you to join on one field, but that is OK, it will give us a good start.
Once the Wizard is completed, open the query in Design View, and create LEFT JOINS between all the other fields in the two tables.
If you are unsure how to do that, see this: http://www.techonthenet.com/access/queries/joins2.php

Unfortunately, the query will not tell you which fields have changed. But they will return all records that do not have an exact match in the other table.