|
-
Jul 29th, 2010, 12:19 PM
#1
Thread Starter
Lively Member
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|