Append Query Not working - Duplicate Output Destination error

[runningphan]

I have kind of a strang Append Query and it isn't working. I have a field in a table that needs to be updated by potentially 10 different fields in another source. For example 'Shelf' needs to be updated by 'Shelf0' or 'Shelf1' or 'Shelf2'...'Shelf9' depending on which has data.

Here's the code that is breaking:

IIf(IsNull(existing_items!BinX0),new_remstar_items_list!Shelf,"RXA" & existing_items!BinX0) AS Expr1,
IIf(IsNull(Existing_Items!BinX1),new_remstar_items_list!Shelf,"RXA" & Existing_Items!BinX1) AS Expr2,

The beginning of the SQL statement references Shelf, Shelf,...up to 10 Shelf's as well.

Is there a way around this?

Thanks!

 

[PHV]

Have a look here:

http://r937.com/relational.html

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886