Comparing Data Differences Between Two Identical Access Tables

[InstructorGirl]

I don't know if I should be posting this question here or if this is a programming question. I have two identical Access tables, for example tblDataYesterday and tblDataToday. The data from tblDataToday has updated data changes in it that are different from tblDataYesterday. I have a maximum of 100 fields to review. I want to compare the two tables and display in a query the differences between the data from both tables. Is this possible? Any help is appreciated. Thank you!

 

[plog]

I'm sure its possible, its just a matter of how many lifetimes you have to spend on it.

First, why do you want to do this? What's the end game? Do you have to do something with the records that changed? A report? As an outsider looking in, it seems tblDataToday should be the correct data and tblDataYesterday is now disposable. Why is that not the case?

Second, 100 fields? That screams improper structure. Can you post a list of the fields? Some sample data would help even more.

Third, what stays the same between the tables? How do you find matches between tblDataYesterday and tblDataToday? What's the primary key?