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 Westi 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
Jul 20, 2005
11
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
Status
Not open for further replies.

Similar threads

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

Part and Inventory Search

Sponsor

Back
Top