ACC: How to Create a Top N Values per Group Query (153747)
The information in this article applies to:
- Microsoft Access for Windows 95 7.0
- Microsoft Access 97
This article was previously published under Q153747
Moderate: Requires basic macro, coding, and interoperability skills.
SUMMARY
This article shows you two methods that you can use to create queries that
list only the top N items per group. By using either one of these methods,
you can create a query, for example, that displays only the top five salespeople for each region.
The second method described in this article assumes that you are familiar
with Visual Basic for Applications and with creating Microsoft Access
applications using the programming tools provided with Microsoft Access.
For more information about Visual Basic for Applications, please refer to
your version of the "Building Applications with Microsoft Access" manual.
REFERENCES
For more information about subqueries, search for subqueries, and then
SQL subqueries using the Microsoft Access 97 Help Index.
Modification Type: | Minor | Last Reviewed: | 10/11/2006 |
---|
Keywords: | kbhowto kbProgramming KB153747 |
---|
|