Append query without duplicates using two id's

[sdel_nevo]

Hi Guys

I am really sorry if this has been asked before, but I am struggling with an Append query

I have 2 tables "UnexUpdateData" and "UnexData"

both these tables hold the following

ID, salesOrder, WO, AccountName, ItemNumber, Decription,ValueCE, and SEQID

I am trying to append data from the "UnexUpdateData" table to the "UnexData" table where the salesorders and SEQID are not duplicated.

this is the code I am using for the append query

INSERT INTO UNEXData ( ID, SalesOrder, WO, ACCOUNTNAME, ITEMNUMBER, DESCRIPTION, VALUEœ, QTYINSTOCK, QTYOUTST, DUEDATE, SEQID )
SELECT UnexUpdateData.ID, UnexUpdateData.[Sales Order], UnexUpdateData.WO, UnexUpdateData.[ACCOUNT NAME], UnexUpdateData.[ITEM NUMBER], UnexUpdateData.[DESCRIPTION-1], UnexUpdateData.[VALUE œ], UnexUpdateData.[QTY IN STOCK], UnexUpdateData.[QTY OUTST], UnexUpdateData.[DUE DATE], UnexUpdateData.SEQID


FROM UnexUpdateData;

how can I stop the duplicate entries being appended

any help on this would be fantastic

Steve

[NTC]

You really need to step back from Append and focus on a simple select query. You want to create a select query that always results in the record set you seek....which is one without duplicate entries... Once that is established - then create an Append query using this Select query as its record set starting point.

[sdel_nevo]

HI NTC

great idea many thanks

will work on that now

Cheers

Steve