Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sorting for multiples

Status
Not open for further replies.
hwagner

hwagner

Programmer
Joined
Jul 20, 2005
Messages
11
Location
US
I need some guidance. I have a table with 11 columns and 2200 rows. I have duplicates of some of the rows, and I only want to see them if the same row is in there 5 times or more. can this be done?

Thanks
 
Sort by date Sort by votes
Hi
You can use the Find Duplicates query wizard. Then edit it to change the criteria for "Number of Dups" from >1 to >4
 
Upvote 0 Downvote
Thank you soo much that was so easy.

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

datajockey123
  • Locked
  • Question Question
Note / Information box with date and time stamp for each entery
Replies
2
Views
996
dhookom
dhookom
JK Dutta
  • Locked
  • Question Question
requet for form an access query for report
Replies
2
Views
5K
dhookom
dhookom
monkeysee
  • Locked
  • Question Question
Select Query for append query
Replies
12
Views
1K
monkeysee
monkeysee
SoLost1
  • Locked
  • Question Question
Please Help for Passing Multiple Select ListBox Values as Parameter for WHERE IN clause of Query
Replies
3
Views
560
dhookom
dhookom
RanaH
  • Locked
  • Question Question
Issues with sorting combo box on form
Replies
1
Views
311
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top