Microsoft Access 2010 Bible

Chapter 20: Advanced Access Report Techniques

721

FIGURE 20.14

An interesting query that sums data and sorts the query results in descending order of the sum.

Tip
The Access Query Builder’s aggregate functions perform flawlessly. Furthermore, Jet will perform the aggre-
gate function exactly the same way every time the query is run. There is no reason you should be tempted to
manually sum data when the query will do it for you.

The basic report (rptUnNumberedList) prepared from the data provided by qryCustomer-

PurchasesJanuary is shown in Figure 20.15. All sorting options have been removed from the

Group, Sort, and Total dialog box to permit the records to arrange themselves as determined by

the query.

FIGURE 20.15

A straightforward report (rptUnNumberedList) produced with data from qrySalesJanuary