Microsoft Access 2010 Bible

Part I: Access Building Blocks

328

Sort fields are selected by the same method you use for selecting grouping fields. You can select

sorting fields that haven’t been chosen for grouping. The fields chosen in this dialog box affect only

the sorting order in the data displayed in the report’s Detail section. Select ascending or descending

sort by clicking the button to the right of each sort field.

Selecting summary options

Near the bottom of the sorting screen of the Report Wizard is a Summary Options button. Clicking this

button displays the Summary Options dialog box (shown in Figure 9.8), which provides additional dis-

play options for numeric fields. All the numeric and currency fields selected for the report are displayed

and may be summed. Additionally, you can display averages, minimums, and maximums.

FIGURE 9.8

Selecting the summary options

Details and summaries

Select for summary report

You can also decide whether to show or hide the data in the report’s Detail section. If you select

Detail and Summary, the report shows the detail data, whereas selecting Summary Only hides the

Detail section and shows only totals in the report.

Cross-Reference
In Chapter 20, you’ll learn how to programmatically control detail and summary reporting options.

Finally, checking the Calculate Percent of Total for Sums box adds the percentage of the entire

report that the total represents below the total in the group footer. If, for example, you have three

products and their totals are 15, 25, and 10, respectively, 30%, 50%, and 20% shows below their

total (that is, 50) — indicating the percentage of the total sum (100%) represented by their sum.