You might want to analyze your data in groups to determine, for example, attendance numbers by film title. Select Query, then Group, or click Group to activate this function. You might be familiar with this procedure from using Access mdb queries, shown in Figure 7-10.
Use the combo box in the Group By column to select the settings shown in Table 7-4 for views.
|Group Type||SQL Function||Description||Access Mdb Equivalent|
|Group By||Defines a grouping criterion.|
|Sum||SUM||Calculates the sum of all values in a column.|
|Avg||AVG||Calculates the average ...|