Check and Remove duplicate data using Access

Hello everyone,


How can i check that their is an duplicate data in the table and after checked how can i remove.It's easy to set up a query to show all duplicate data by using the query wizard,but how can i remove 1 instance of the duplicate?

There's no restrictions on the data table.

How much data do you have in your database????

Around thousand records are their in my database.

Are the records complete duplicates or just duplicated in a field.

some of my records are completely duplicate....
basically their r two copies in total, sometimes three.

I want 1 record remaining

You can do this by following these steps:

1) Make a copy of your table and delete all the records from the copy.

2) Set the field properties for one of the duplicate fields to not accept duplicates. You go to the bottom of the table design page and you will see Indexed. Select Yes No Dupilates

3) Make an Append query to append the original table to the copy and all the duplicates will be knocked out.

you can use a select distinct query.

Create a Make table query with a "group by" on all the fields and you should get a new table with non duplicate. when you think you have it all replace the old table with the new table create from the query.