• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 35. Creating a Report > Sorting and Grouping Records in a Report

Sorting and Grouping Records in a Report

A report can group together similar records (for example, all the employees that have the same department in the Dept field), and it can also sort the entries within groups.

To sort and group records:

1.
With the report open in Design view, click the Sorting and Grouping button on the Access toolbar (Figure 35.23).

Figure 35.23. Click the Sorting and Grouping button.


2.
In the Sorting and Grouping dialog box, use the drop-down menu to select the field you want to group on (Figure 35.24).

Figure 35.24. Select fields in the Sorting and Grouping dialog box.


or

Drag a field from the field list.

3.
Select the sorting method for the grouping.

4.
If you want, select a second field to group on, within the first grouping .

5.
Click a new row to save your changes.

6.
Close the dialog box.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint