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?
To actually do the compares, you will need three different queries.
A left join to find adds
A Right join to find deletes
An Inner Join where you compare column by column to identify field differences.