Datasheet

Book VI
Chapter 1
Building and
Maintaining Data Lists
593
Subtotaling Data
Here, I selected the Dept field as the field for which the subtotals are to be
calculated in the At Each Change In drop-down list box, Sum as the function
to use in the Use Function drop-down list box, and the Salary check box as
the field whose values are to be summed in the Add Subtotal To list box.
Figure 1-14 shows the results I obtained after clicking OK in the Subtotal
dialog box. Here, you see the bottom of the data list showing the salary
subtotals for the Administration, Engineering, Human Resources, and
Information Services departments along with the grand total of the salaries
for all the departments. The grand total is displayed at the bottom of the
data list because I left the Summary below Data check box selected in the
Subtotal dialog box — if I hadn’t wanted a grand total, I would have removed
the check mark from this check box.
Figure 1-13:
Using the
Subtotal
dialog box
to subtotal
the salaries
for each
department.
Figure 1-14:
Bottom of
the data list
showing the
subtotals
and grand
total for
department
salaries.
30_489598-bk06ch01.indd 59330_489598-bk06ch01.indd 593 3/27/10 12:46 PM3/27/10 12:46 PM