Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

How do I remove duplicate records from a table?

Discussion in 'Information Technology' started by CyberQban, Jul 28, 2006.

  1. CyberQban

    CyberQban
    Expand Collapse
    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
     
  2. Loading...


  3. arthurjr07@gmail.com

    arthurjr07@gmail.com
    Expand Collapse
    Guest

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

    Select * From TableName where CatalogID in
    (Select CatalogID From TableName
    Group By PartNumber)
     
  4. arthurjr07@gmail.com

    arthurjr07@gmail.com
    Expand Collapse
    Guest

    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)
     

Share This Page