Results 1 to 1 of 1
  1. #1
    Join Date
    Nov 2004
    Posts
    51

    Smile Unanswered: Merging Duplicates within a single table


    Here's my problem.... I have approx 12500 total entries in a table with about 10000 of those being duplicates. Some of the dups have different info in them. Is there any way to merge the dups into a single entry with all the info?

    For example:

    NAME DATE1 DATE2 DATE3
    JOHN 9/9/99
    JOHN .....................8/8/88
    JOHN 9/9/99.....................7/7/77
    JOHN 8/8/88.......8/8/88 -------->and will this
    particular entry cause a
    problem due to a different
    date?

    Merged to:
    NAME DATE1 DATE2 DATE3
    JOHN 9/9/99 8/8/88 7/7/77
    Any help would be much appreciated
    Last edited by sewmap; 11-18-04 at 01:14.

Posting Permissions

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