O'Reilly logo

Microsoft® Access Projects with Microsoft SQL Server™ by Natascha Nicol, Ralf Albrecht

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Groups

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.

Figure 7-10. View with groups

Use the combo box in the Group By column to select the settings shown in Table 7-4 for views.

Table 7-4. Aggregate Functions for Grouped Columns 
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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required