Query that shows all differences between two tables.
Posted on 2014-11-25
After I import my new bill of material part list into access. I need a query that compare that entire table with the entire existing table and create a table with the differences. Some parts could have been deleted, some added, and some the quantities could have changed, different rev levels, weight change, etc., then I need it to create a table with the differences. I've managed to create two queries to create two separate tables, a parts added and a parts deleted table. This, however, isn't exactly what i need.
Also, after all of that happens, I need to update the existing table with all of the changes. Can anyone suggest the easiest way to accomplish this?