which query to use???

[joltremari]

I am currently using an Append query then running a find duplicates query so I can remove any duplicates that were created by the Append query.

What I would like to do is have a query that will not overwrite anything that is existing or have a query that will merge existing data and any new data together.

Can anyone help me with this....

Thanks,
JO

 

[Rich]

Look for duplicates first, then append, just change the look for duplicates query into an append using the same criteria.
HTH

 

[Pat Hartman]

Why not define a unique index so the duplicates won't be appended.