Removing duplicates

[DAVID W]

I have data that I want to combine. However the separate data sets have some duplicates.
Let's say it is Customer Num field.
What I am saying is I am trying to combine the data sets to make a table with Customer Num and Customer Name.
I want to eliminate the duplicates.
What is the best way to do this?
Is there a feature in Access for this?

[RayMilhon]

Create a Group By Query with the fields you need. Each record will be unique

[alansidman]

Here is an alternative solution

http://www.datapigtechnologies.com/f...teproblem.html

[ajetrumpet]

Here is an alternative solution

http://www.datapigtechnologies.com/f...teproblem.html

that is good, but if you google you WILL find automation out there to remove duplicate records from Access tables, based on any number of duplicated fields. Unfortunately, the wonderful qry wizard in access just shows you the dups, doesn't delete them, which is incredibly stupid.

We STILL have to write our own solution for this.

[DAVID W]

Well I think I have found a solution for my problem of getting rid of duplicates.
Excel 2010 has, under DATA dropdown menu at the top, a remove duplicates selection. I used this on my data and it seemed to remove the duplicates as I wanted. This feature was not hard to use. Now I can import the data as a table into Microsoft ACCESS.

[DAVID W]

See my last post.
Thanks.