Copy records without dupliacates

[cmweb via AccessMonster.com]

Hello

I need a query to copy records from a table to another table without
duplicates.

Many thanks in advance and your help is most appreciated.
Carlos

 

[Allen Browne]

Use the Unmatched Query Wizard (first dialog when you create a query) to
select the records from table1 that are not in table2.

Then turn it into an Append Query (Append on Query menu) to add these
records to the target table.