Limit Records in a Microsoft Access Report

摘要

You'll often hear complaints that you must use VBA code to do certain things. Sometimes, those complaints are valid. However, you can often get Access to do what you want with little or even no code. Limiting the number of records in a group is a good example. For instance, suppose you want to return the top five orders for each customer. Or, perhaps you'd like to see the top salesperson for each region. Many developers solve this problem using VBA code, but you can do it without code.