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. OP
    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. OP
    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)
     
Since you're here... we have a small favor to ask...     Become a Supporter      ::     Make a Contribution     


Share This Page