Understanding Databases – Grouped Reports
Either create a new report through the wizard or edit an existing report in Report Design View.
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.
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.
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.