Chapter 18: Advanced Access Query Techniques
677
Summary
This chapter has taken a look at just a few of the possibilities when using Access queries to perform
calculations and data transformations. The benefit of performing these operations at the query level
is that the calculations are performed dynamically, and consistently, no matter where the data is
used.
Access totals queries provide many options for grouping, sorting, and filtering data before applying
calculations to the data. Alternatively, calculations may be performed before filtering so that only
certain records are returned by the query.
Finally, crosstabs are a powerful tool for summarizing data. When properly constructed, crosstab
queries reveal patterns and valuable information not obvious from simple select queries. The abil-
ity to choose fields used as row and column headers, and the calculations to perform on the cross-
tab fields, is a powerful addition to your Access development toolkit.