hi
i am looking for different values (quantity) in the same column in two tables with same format (same column headings).
One is the old version of our db and the other one is the new version.
These were originally excel files that i downloaded into Access as two tables and looked for unmatched records in them.
so 2 tables are exactly the same format but there has been some changes in the new table mainly quantity of the orders.
i appreciate any help :)