Microsoft Office Tutorials and References
In Depth Information
Trouble? If the Group, Sort, and Total pane is not open at the bottom of the
screen, click the Group & Sort button in the Grouping & Totals group on the
You can click the Group &
Sort button in the Grouping
& Totals group to open and
close the Group, Sort, and
Because the rptContract report has a grouping field and a sort field, the Group & Sort
button is selected, and the Group, Sort, and Total pane is open at the bottom of the
screen. In the Group, Sort, and Total pane , you can modify the report’s grouping fields
and sort fields, and the report calculations for the groups. A grouping field is a report sort
field that includes a Group Header section before a group of records having the same
sort field value and a Group Footer section after the group of records. A Group Header
section usually displays the group name and the sort field value for the group. A Group
Footer section usually displays subtotals or counts for the records in that group. The
rptContract report’s grouping field is the CustomerID field, which is displayed in a Group
Header section that precedes the set of contracts for the customer; the grouping field
does not have a Group Footer section. The ContractNum field is a secondary sort key, as
shown in the Group, Sort, and Total pane.
Because you don’t need to change the grouping or sort fields for the report, you’ll
close the pane and then make Sarah’s modifications to the report.
To modify the report in Layout view:
1. In the Grouping & Totals group on the Format tab, click the Group & Sort button
to close the Group, Sort, and Total pane.
First, you’ll increase the height of the Contract Type column.
2. Scroll down the report to CustomerID 11083, which has the longest field value in
the Contract Type column, click the ContractType field value for ContractNum
3043, move the pointer to the bottom edge of the selected value, and when the
pointer changes to a shape, drag down the bottom edge to increase the height
to display two lines. See Figure 7-6. After you make a resizing adjustment to the
control, the portion of the report you’re using as a basis for the resizing might
move off the screen, and you might have to scroll back to it.
After resizing the Contract Type column
Next, you’ll change the format of the field values in the Contract Amt column to