I am testing a very simple system. I have 2 tables with some overlapping records, lets call them table 1 and table 2.
I have set a query to compare the list of table 1 to table to in a way to list all records that are in table 2 but not in table 1. Lets all this Query 1.
I have another table, lets call it Full List, where I have a copy of table 1.
I am trying to use append query to push the results of Query 1 to Full List. This is giving me the error "Duplicate Output Destination 'ID' ".
Any idea on how to solve this problem?
Thanks in advance
I have set a query to compare the list of table 1 to table to in a way to list all records that are in table 2 but not in table 1. Lets all this Query 1.
I have another table, lets call it Full List, where I have a copy of table 1.
I am trying to use append query to push the results of Query 1 to Full List. This is giving me the error "Duplicate Output Destination 'ID' ".
Any idea on how to solve this problem?
Thanks in advance