Copy records without duplicates

CMontoro

Registered User.
Local time
Today, 07:46
Joined
Mar 26, 2005
Messages
21
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
 
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.
 
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.
 

Users who are viewing this thread

Back
Top Bottom