View Data in a Database Table
 
 
 

To specify a sort order for the Data View window display

  1. Right-click any column header in the Data View window. Click Sort.
  2. Select a column to sort in the Sort By list. Select Ascending or Descending to specify a sort order.

    Ascending order sorts the column starting with the smallest value and ending with the largest value. Descending order sorts the column starting with the largest value and ending with the smallest value.

  3. If desired, select an additional column to sort in the Then By list. Select the Ascending or Descending option to specify a sort order.

    The sort operation sorts all database table records according to the value specified in the Sort By list, and then continues to sort based on the value specified in the Then By list.

  4. Repeat step 2 for any additional fields that you want to add to the sort.

    You can sort by a combination of up to five table columns at a time.