Recent content by Jacquilov

I created 2 tables with one common identifier "Ship ID". The Master Table and the Monthly Table I need to create a query to show only the records from the Monthly table that does not exist in the Master Table and the records from the Master table that does not exist in the Monthly Table. Please...

:(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

Thanks for your input.

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.