You can customize a report in the following ways:

Record source Change the tables and queries that a report is based on.

For more information, see the topics Change the record source or connection information and Bind a blank form or report to one or more tables or queries.

Sorting and grouping data You can sort data in ascending or descending order. You can also group records on one or more fields, and display subtotals and grand totals on a report.

For more information, see the topic Sort records (MDB).

Report window You can add or remove Maximize and Minimize buttons, change the title bar text, and other Report window elements.

For more information, see the topic Customize a form or report window.

Sections You can add, remove, hide, or resize the header, footer, and details sections of a report. You can also set section properties to control the appearance and printing of a report. For more information, see the following topics:

• About sections of a form
• Add or remove a section
• Show or hide a section
• Resize a section
• Keep the contents of a section together

Controls You can move, resize, or set the font properties of a control. You can also add controls to display calculated values, totals, current date and time, and other useful information on a report.

• About types of controls in Access
• About creating controls
• Add a field to a form, report, or data access page
• Bind a control to a field
• Create a subreport
• Show current date and time
• Show page numbers
• Calculate a total or other aggregate values
• Calculate a value