Append query problem - "duplicate output destination"

M

Matt Dawson

I have just created an append query on a previous match query where it found
all ID;s that were in one table but not in the other.
However, when i try and run this query it gives me the error "duplicate
output destination" as it tries to include the "Is Null" ID from which i am
using to create the match
Does anyone have any ideas as to how to work around this?
Many THanks
Matt
 
J

John Spencer

Usually this means that you are trying to assign something to a field in two
different columns. If you are using the grid, make sure that you don't
have the same field with Append to filled in.

Otherwise, post your SQL statement and someone should be able to spot the
difficulty.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 

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

Similar Threads

Append Query is not working 1
Append: Duplicate Output Destination error 4
Duplicate Output Destnation 'ID' 0
Duplicate output destination 1
Unmatched Append help 4
remove duplicate records in Access 2007 7
Append query with an Inner Join to Destination Table Not working 2
Criteria in append querie 3

Top