Sort the data in a table by fields or expressions.
To sort a table
- In the Layout view, select the table, right-click and choose Properties.
- On the Sorting page, enter an expression in the Expression column by which to sort the data in the table.
-
In the Direction column, select whether you want to sort the data in an Ascending or Descending direction.