Grouping is an indispensable tool for making sense of large volumes of data by arranging them into smaller groups. You can then perform calculations on each individual group. Consider a list of orders in the Boutique Fudge company. Depending on how you want to group your data, you can consider whether chocolate milk outsells chocolate beer, whether customers in New York crave more cocoa than those in Alabama, and so on.
Figure 11-17. Top: The expression looks like an ordinary text value in Design view. Bottom: When you preview the report, Access performs the calculation and then shows the result.