Grouping by sorting
You can configure the view settings so that when you click a column heading the records get not only sorted by this column but also grouped. The previously applied grouping (if any) will be cleared.
To enable automatic grouping:
-
Select View > Customize View from the main menu to open the Customize View window and click the Options tab.
-
Under Grouping, select the Group by Sorting check box.
-
Click OK.
To disable automatic grouping:
-
Select View > Customize View from the main menu to open the Customize View window and click the Options tab.
-
Under Grouping, click to clear the Group by Sorting check box.
-
Click OK.
NOTE: Selecting this check box has no effect if you sort records by using the Sorting tab of the Customize View window or grid pop-up menu commands.