Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Mar 2005
    Location
    Leicestershire, United Kingdom
    Posts
    506
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi,

    I haveused the access query for finding duplicate records in an access table.

    For each instance of a duplicate, I need to keep the latest record (the one with the higher primary key field), but update various tables with the new primary key from the old one.

    For example, the primary key is 'PurchID' and I would need to update four / five tables and then delete the redundant records.
    Best Regards,

    Luke

  2. #2
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts
    Quote Originally Posted by Lstclair55 View Post
    Hi,

    I haveused the access query for finding duplicate records in an access table.

    For each instance of a duplicate, I need to keep the latest record (the one with the higher primary key field), but update various tables with the new primary key from the old one.

    For example, the primary key is 'PurchID' and I would need to update four / five tables and then delete the redundant records.
    There's NO easy answer to this one Luke.
    [attachment=87283emoDuplicates.zip]

    Have a look at the queries in this attached example.
    It may answer your query
    and then again......

    Attached Files Attached Files
    Andrew

Posting Permissions

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