|
A Crosstab
Query can use many math functions including: Avg, Count, First,
Last, Max, Min, StDev, Sum, Var. 6.
Try it: Select a Function Select a
Field: MovieID. Select a
Function: Count. What Do
You See? By default, there is a check mark
to include row sums. Click
Next. Keep
going...
Exam 77-885: Microsoft Access 2010
4. Creating and Managing Queries
4.1. Construct queries: Create a
Crosstab Query
Create ->Queries ->Query Wizard->Crosstab Query Wizard |
|
| |
