Remove duplicate records

[Roger Bell]

I have a data base with 3 fields, namely Name, Company and address. This Data
Base contains some duplicate records; ie the information is identical in all
the 3 fields.
I would like to remove those records where there are duplicates. Would I
write a delete query or append to a new table? And how would I go about this?

Thanks for any help?

 

[John W. Vinson]

I have a data base with 3 fields, namely Name, Company and address. This Data
Base contains some duplicate records; ie the information is identical in all
the 3 fields.
I would like to remove those records where there are duplicates. Would I
write a delete query or append to a new table? And how would I go about this?

Thanks for any help?

It's actually easiest to create a new table. Copy and paste the table into the
tables window under a new name; choose the option "structure only", don't copy
the data.

Open the new (empty) table in design view. Ctrl-click all three fields and
click the Key icon to make them a joint, three field primary key.

Close the table; open the Queries window, create a new Append query based on
the old table, and append the data into the new one.

John W. Vinson [MVP]