Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Mar 2003
    Location
    Toronto, Canada
    Posts
    101
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Duplications (XP)

    A client of mine has a table that has duplicate records. Is there a way to delete those records using a query or any other tricky feature?
    If so.. How

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Duplications (XP)

    How much work it is depends on how many records and how many duplicates there are, and whether there are related records in other tables. Sometimes, the weeding out of duplicates can be automated, sometimes it requires manual pruning.

    Say that you have a Customers table with duplicates, for example customer #21 and customer #37 are actually the same. If there are records in the Orders table for customer #21 and also for customer #37, you'll have to decide which customer# to keep, say #21, then change #37 to #21 in the Orders table. You must do this before removing duplicates from the Customers table.

    You can use the FindDuplicates Query Wizard to create a query that lists all duplicates. If the number is small, you can use this to delete the superfluous recods manually. If the number is large, it depends on the situation whether it is possible and feasible to spend time in automating things.

  3. #3
    2 Star Lounger
    Join Date
    Mar 2003
    Location
    Toronto, Canada
    Posts
    101
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Duplications (XP)

    What is the long way? I like your suggestion and that is how i personally would have done it but the client does not want to to do any manual work even though she could be completed it by now. [img]/forums/images/smilies/sad.gif[/img]

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Duplications (XP)

    Well, is there a way to decide which record to keep? Either something to do with the contents, or something simple such as "keep the one with the highest (or lowest) value of the primary key"?

    And are there related records that should be updated first?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •