Remove Duplicate records...

[smpayne]

This is probably pretty simple, but I am very new to Access. I have created a table and there are duplicate account numbers in the first column of the table. How do you remove the duplicates from the table?? Is there are query I can use?

Any assistance would be appreciated!

Shawn.

 

[sfreeman@co.mer]

Use the Access Find Duplicates Query Wizard

Should look something like this:

SELECT
TableThreeID.Test1
, TableThreeID.ID1

FROM
TableThreeID

WHERE
(((TableThreeID.Test1)

In
(SELECT [Test1]

FROM
[TableThreeID]

As
Tmp

GROUP BY
[Test1]

HAVING
Count(*)>1 )))

ORDER BY
TableThreeID.Test1;


HTH