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. The are joined together with a primary key of myID. I have a maximum of 30 fields to review. I want to compare the two tables and display in a query the data values that have changed between the two tables.
For example, the tables have myID, FirstName, LastName, etc.
The last name value yesterday was Smith, today it is Jones, the first name has not changed. I want to display ONLY the changed data which is the LastName.
Is this possible with SQL queries? Or will I have to write this in VBA? I am not very adept a writing in VBA. Any help is appreciated. Thank you!