Duplicate Values

[abusaif]

Good Morning,



Guys by mistake I created duplicate values to my DBs table by appending from excel. Now I created a duplicate query which shows me all records duplicated.
Now is there any way to delete only the duplicated record and Leave the right one. (As I have 2 records for each so in plane english I want to keep one and delete the other)

Thanks for your time

[JoeM]

One way would be to create an Aggregate Query to "weed out" duplicates.
You can then use that query in a Make Table or Append Query to write those records to a new table without duplicates.