1. Open an existing table or create a new table
2. To modify an existing table, right-click on the table and select Design >> Table Properties(to display the Table Properties dialog box). For creating a new table, navigate to File>>New>>Table>>Select the records for which the data to be fetched into the table
3. Select the records for which the data needs to be sorted
4. Click Sorting button to display the Sorting records dialog box
5. Enter information for the following fields, as needed:
- Sort By (1-8)
- Descending
- Records Are Grouped Within Their
- Repeat Headings for Each Group of Records
6. Click OK twice to close the Sorting and Table Properties dialog boxes respectively