Sort data on a data access page

You can sort data on a data access page, including data that's grouped. For grouped data access pages, you can sort the list of groups or the records within a group.

1. Do one of the following:
   • In an ungrouped page, click the field you want to use for sorting records.
   • In a grouped page, expand the group that you want to sort, and then click the field you want to sort records on.

     Note   When you sort records within a group, the sort order only applies to that group. It does not affect the order of records in other groups. For example, say a data access page is grouped by region, the region names are listed in ascending order, and under each region employees are listed in ascending order by their last name. If you display employee records for Mexico and then sort employees in descending order by last name, then the employee records for other regions will still be sorted in ascending order, as will the list of regions themselves.

2. Do one of the following:
   • To sort in ascending order, click Sort Ascending .
   • To sort in descending order, click Sort Descending .

Notes

• If the records are displayed in tabular format, simply click the label of the field you want to sort records on. The records will display in ascending order. To sort records in descending order, click the label again.
• If you browse to another data access page and come back to this page, you'll lose the sort order.
• The order in which numbers, text, and special characters are sorted depends on the database and your regional settings in Microsoft Windows Control Panel.

• This procedure doesn't apply to a Microsoft Office PivotTable Component, Spreadsheet Component, or Chart Component. These features can be sorted independently from the rest of the data on the data access page, and may also support additional sorting capabilities. To display help for a PivotTable list, spreadsheet, or chart, click Help on its toolbar.