Results 1 to 5 of 5
  1. #1
    TundraMonkey is offline Novice
    Windows XP Access 2007
    Join Date
    Jun 2009
    Posts
    20

    Question Deleting Duplicates

    Hello,



    I haven't found an answer in the archives, and would appreciate the help:
    A Find Duplicates query has yielded over 7,000 records, and I need to get rid of the duplicates. My delete query ends up deleting both copies of the record.

    Any help is greatly appreciated - thank you!

  2. #2
    TundraMonkey is offline Novice
    Windows XP Access 2007
    Join Date
    Jun 2009
    Posts
    20
    I am still searching for an answer to this one... perhaps this can't be done in Access. For now I am exporting the table into Excel, having Excel delete duplicate records, and then importing the table anew. For all pairs of duplicated records, the delete query in Access deletes both copies. Any help is greatly appreciated...

  3. #3
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,923
    You would need to walk through the Find Duplicates query deleting records that are duplicates.
    (RG for short) aka Allan Bunch Previous MS Access MVP - WinXP Pro, Win7 Pro Win10 Pro - acXP, ac07, ac10, ac13
    How to mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,923
    I just found a clever alternative way to do this:
    http://www.datapigtechnologies.com/f...teproblem.html
    (RG for short) aka Allan Bunch Previous MS Access MVP - WinXP Pro, Win7 Pro Win10 Pro - acXP, ac07, ac10, ac13
    How to mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

  5. #5
    thhui is offline Competent Performer
    Windows XP Access 2002 (version 10.0)
    Join Date
    Feb 2009
    Posts
    235
    RuralGuy's approach is an indirect way to eliminate duplicate entries.
    The result is alright.

    It isn't eliminate any entries of the original database but
    create a new one without duplicates.

    I also use this approach somehow.

    There is an alternative way that eliminate the original database duplicate entries.
    But the performance is somehow poor.
    It use vba program to loop through the whole set of records and eliminate the entries when it found the duplicates.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Pulling out duplicates
    By FREEEEEEDOM in forum Access
    Replies: 1
    Last Post: 04-21-2009, 10:37 PM
  2. Hide Duplicates with Group Headers
    By diwin in forum Reports
    Replies: 0
    Last Post: 03-26-2009, 09:32 AM
  3. Replies: 0
    Last Post: 01-08-2009, 05:49 PM
  4. Replies: 1
    Last Post: 05-27-2006, 12:35 PM
  5. Deleting Spaces
    By grgerhard in forum Import/Export Data
    Replies: 2
    Last Post: 04-30-2006, 06:42 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums