I have two tables in Access and i want to compare for data change before updating the master table. the tables have 3,259 records and id like to at least automate the process. I know i could use the update query but what is the best way to compare the data first before updating any changes????