Duplicate Output Destnation 'ID'

Joined
Oct 17, 2012
Messages
1
Reaction score
0
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top