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!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Bottom N Records Per Group
Thanks!!! I'll just get a count of the records per group, so I'll know how many to query for the Top N records, then get those records not in the list. Thanks for your help!!!- tripsma
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Bottom N Records Per Group
Does anyone know how to get the "Bottom" N records instead of the Top N in MS Access per group? I know you can set the properties in a query to get the Top N records, but I need the Bottom N records (like the 1st 6 records per group, for example). Does anyone know how to pass a value...- tripsma
- Thread
- Replies: 2
- Forum: Microsoft: Access Modules (VBA Coding)
