How do I remove duplicate records from a table?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

tblCatalog consist of the following fields:
CatalogID = key
PartNumber (Duplicates)
Description
ListPrice
ASUPrice

I have duplicate part numbers in the Part Number field. I have read
BerHav's response and Raghu's.

In BerHav's response, but after the SELECT Distict... "What?" Unclear.

In Raghu's response, far more detailed (Great!, but) when I clicked on the
"new table", of course there is no data because we entered "Structure Only"
so... no data would be there.

HELP!!....

MS Access 2003
 
try,
Create a query and use this SQL in that query.

Select * From TableName where CatalogID in
(Select CatalogID From TableName
Group By PartNumber)
 
try,
Create a query and use this SQL in that query.

Select * From TableName where CatalogID in
(Select First(CatalogID) From TableName
Group By PartNumber)
 
Back
Top