Copy records without duplicates

[CMontoro]

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

 

[Cicak]

Would an append query do the job? You could find out how to create an append query in the microsoft office help. From what I understand, such a query copies records from one table to another, within the same database or in another database. If there are duplicate records in the 'destination' table, then Access will tell you how many are duplicates and you won't be able to send those over.

 

[georgedwilkinson]

If there are duplicate records in the 'destination' table, then Access will tell you how many are duplicates and you won't be able to send those over.

Only if there is some kind of unique constraint or primary key which disallows duplicates. Cicak's is good advice.