:(I created 2 tables with one common identifier "Ship ID".
The Master Table and the Monthly Table
I need to create a query to extract the records from the Monthly table that does not exist in the Master Table.
What should I do?
How would I do a vlookup in access to identify missings transactions from 2 tables.?
I created the Master Table and I want to extract only the transactions not listed in the Master Table from the Query Table.
Master table has 98 records Query Table has 250 records
I have created 2 tables in access and I am trying to find the Ship IDs in the 2nd table that are not in the 1st table. How can I do a vlookup to pull the data I need.