remove duplicate data

[Guest]

Hi,

I have a list of approx 14,000 names (with name and address fields). How can
I create a query to remove duplicate entries by checking the name and address
fields?

I am very new to access so please be gentle

Thanks

 

[Guest]

You don't have to delete the records, you can create an Unmatch records
query, using the query wizard.

If you still want to delete it, first CREATE BACK UP to your data.

My prefer way is to create a Table just as the first one.
Create a key in the table that includes the name and address
Append all the records from the old table to the new one.

The duplicates wont be appended.
Change the name of the new table to the name of the old one.

That should remove the duplicates, and wont allow new duplicates to be enter
in the future

 

[Guest]

How do you append the records from the old table to the new one?

thanks

 

[John W. Vinson]

How do you append the records from the old table to the new one?

With an Append query.

Create a Query based on the old table. Change it to an Append query with the
Query menu option, or the query type tool in the toolbar. Follow Ofer's
suggestions about which fields to include.

John W. Vinson [MVP]