Understanding Databases – Grouped Reports

Either create a new report through the wizard or edit an existing report in Report Design View.

12 Grouped Report

To group fields, click on the ‘Sorting and Grouping’ icon on the toolbar.

Grouping fields will stop information from being duplicated, for instance if the same person has a home and mobile number stored in the database.

13 Sorting And Grouping

Select a field name for each group from the drop down menus.

Move the fields that you don’t want repeated up to the header for that group.

Use the horizontal line icon to draw a line above the top field to separate records.

14 Output Text

Execute the report to open a text document.

In this example, the report no longer repeats the name and group for records that have both a mobile and home number.