Append Query

[paul.clarke]

Hi

I have set up an append query, but it is duplicating every record in the file, rather than just updating the fields that have changed.

If i hav an "order num" as a primary key in the table, it appears to work, but then i cannot run my update query as it wont allow duplicate order nums.

how can i get round this?

Ideally i would like the update query to update all new records, to the existing table as additional data, (not replacing existing data) and the append query should only update those which have changed,

 

[MStef]

If you want to UPDATE the old records, make an UPDATE query, not Append.

 

[paul.clarke]

I think ive cracked it. i run the append 1st, to add new records, then the update 2nd to capture the changes... i was doing the other way around.