Microsoft Office Tutorials and References
In Depth Information
InvoiceItem is now a bound control in the report in a Group Header section that
displays a field value text box and its attached label. The group band in the Group,
Sort, and Total pane contains the name of the grouping field (InvoiceItem), the sort
order (“with A on top” to indicate ascending), and the More option, which you click
to display more options for the grouping field. You can click the “with A on top”
arrow to change to descending sort order (“with Z on top”).
Notice that the detail records are unsorted, and Lucia’s design specifies an ascend-
ing sort on the InvoiceDate field. Next, you’ll select this field as a secondary sort
field; the InvoiceItem grouping field is the primary sort field.
2. In the Group, Sort, and Total pane, click the Add a sort button, and then click
InvoiceDate in the list. Access displays the detail records in ascending InvoiceDate
order, and adds a sort band for the InvoiceDate field in the Group, Sort, and
Next, you’ll display all the options for the InvoiceItem grouping field, and set
grouping options as shown in Lucia’s report design.
3. Click to the left of the group band to select it, and then click More to expand the
band and display all group options. See Figure 7-23.
After expanding the group band
sorted in ascending
expanded group band
Reviewing Lucia’s report design (see Figure 7-17), you need to delete the
InvoiceItem label, add a Group Footer section, add a grand total and subtotals for
the InvoiceAmt field values to the Group Footer section, and set the Keep Together
property. The Keep Together property prints a group header on a page only if
there is enough room on the page to print the first detail record for the group; oth-
erwise, the group header prints at the top of the next page.