What is the best way to compare two tables to find differences between the data.

Queries.

Have you tried the Find Matched and Find Unmatched query wizards?

Difficult to say much more without knowing what you want to do.

Please don't post the same question under multiple topics.

The find unmatched query wizard will only display differences in the entire record (i.e. if a record exists in one table but not in the other). How would you do something similar but based on the actual fields. For example...

table 1, field 1, value = 'This is my field value'

table 2, field 1, value='This is not my field value'

Note: both tables have identical field structures.

How would I find these differences between the two tables?

The situation is this: I gave a copy of a database to someone who went and made changes/additions to the data (not the structure). While this person was making changes to the copy of the database, changes/additions (not the structure) were being made to the original database. How do I reconsile (or kind the differences) between the tables of the original and the copy of the database?