First I'd make a query which is an inner join between the old and the new table. It has 12 fields in total:
- the four identifying fields
- the four other fields from the old table
- the four other fields from the new table
Then based on that query, use other queries to find out whatever you want to find out.
Be sure to make a new index for those 4 fields combined on both files to speed up the inner join.
Kees
I admit I am a lightweight and I am still using Access 2000, but I hope that means a lot of you will know the answer to this question.
I have two tables (one older) with traffic sign information. They each have 8 fields. I want to do something like an Unmatched Query between the fields that define what each SIGN means when 4 other fields are equivalent.
In other words, when the MAIN STREET, FROM STREET, TO STREET and SIDE OF STREET fields are the same in both tables, I want to compare the SIGN fields to see the changes. Basically, I want to see the changes on the same block and side of the street between the 2 tables.
I think I need some kind of when MAIN STREET = MAIN STREET, FROM STREET = FROM STREET, etc. conditions are met, what are the unmatched fields in the SIGN field, but like I said, I am at a loss.
Any help would be greatly appreciated.

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic