I have two access tables I am trying to compare against each other. The main table is the true source. The input table is a table a receive from a third party. The relationship between the two tables are the following fields:
This makes the record unique. The problem I having i dont know how to create the comparison query in my access basic module to update the tbl_output when the records don't match. I have deleted 25 records from tbl_input and change 5 others. So when complete tbl_output should at least have 30 records in it. So I know my third query needs to some type of outer join between tbl_main and and tbl_input. Thats what I need help building in my access module. I am attaching the database with tables and modules.