Results 1 to 7 of 7

Thread: Finding maximum number of duplicate records in Access Table?

Threaded View

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Jan 2006
    Posts
    89

    Resolved Finding maximum number of duplicate records in Access Table?

    Dear members,
    Here is the sample of my Access Table

    ID SecondaryID
    1 101
    1 101
    1 102
    1 103
    1 103
    1 103
    2 104
    2 105
    2 105
    3 106
    3 107
    3 108
    3 108
    3 108
    3 108


    I want to do is get unique ID having greatest number of duplicate SecondaryID…So that my table becomes in this form


    ID SecondaryID
    1 103
    2 105
    3 108

    Please suggest a query for me....thanx
    Last edited by imstillalive; Feb 15th, 2011 at 10:58 AM. Reason: Resolved

Posting Permissions

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



Click Here to Expand Forum to Full Width