Modify Reports in Layout View: Grouping, Totals, and Print-Safe Formatting
The Modify reports in Layout view domain tests your ability to refine a report's structure and appearance while previewing the actual data, without opening Design view.
Grouping, sorting, and totals
The Group, Sort, and Total pane is the control center in Layout view. Add a group on a field, set sort order and direction, and choose whether to show a group header or footer. The same pane inserts aggregate totals (Sum, Avg, Count, Max, Min) into a group header or footer, and it exposes options such as keeping a group together on one page.
Adding and arranging fields
Drag fields from the Field List to add bound controls; Access inserts them into the existing layout so surrounding controls shift. Adjust column widths, alignment, margins, and padding with the Arrange tools, and apply a theme for consistent typography.
Conditional formatting
Select the controls, open Format > Conditional Formatting, and define Expression Is rules, for example [Freight]>100, so only qualifying rows are emphasized.
What requires Design view
Events, section properties like Can Grow, subreport insertion, and page-number placement are Design view tasks. Layout view never shows page breaks, so always confirm pagination in Print Preview.
Worked example
A report repeats the customer name on every detail line. Reasoning: group the report by Customer using the Group, Sort, and Total pane, move the customer name control into the group header, and leave the detail section for order lines. Deleting the name from the detail section alone would remove it entirely rather than consolidate it.
Traps
- Placing a Sum in the detail section, which repeats it for every record instead of once per group.
- Confusing report sorting in the pane with the sort order of the underlying query.
- Assuming Layout view reflects page breaks and margins - verify in Print Preview.
- Setting a static format instead of a conditional rule when only some rows should stand out.