Microsoft Office Tutorials and References
In Depth Information
Figure 5-19
Aggregate functions used in crosstab queries
Aggregate Function
Definition
Avg
Average of the field values
Count
Number of the nonnull field values
First
First field value
Last
Last field value
Max
Highest field value
Min
Lowest field value
StDev
Standard deviation of the field values
Sum
Total of the field values
Var
Variance of the field values
Figure 5-20 shows two query recordsets—the top recordset (qryCustomersAndInvoices) is
from a select query and the bottom recordset (qryCitiesAndInvoicesCrosstab) is from a
crosstab query based on the select query.
Figure 5-20
Comparing a select query to a crosstab query
individual
Lansing
records
Lansing records
with paid invoices
La n sing records
with unpaid invoices
Search JabSto ::




Custom Search