To do a quick sort on a single field, follow these steps:
Go into Table Grid View and click on the bar above the column (field) you want to sort on. The column will be selected.
Next, right click your mouse and select Sort Ascending or Sort Descending. The records will be sorted according to the values in the column. (You can also right click your mouse anywhere within the column without having first selected the column, except in the current cell if it is in edit mode).
If you repeat the operation on another column, the records will be sorted according to the values in that column without regard for the first sort.
Note: The Sort Order box on the Query toolbar indicates that the sort is Sort Order - Untitled. This is the name given to any temporary sorts you apply to your table and is redefined for each temporary sort you apply.
To cancel a sort and return to the original order of the records, right click anywhere in the table and select No Sort (alternatively, click on the arrow in the Sort Order box and select Sort Order - None from the drop-down list). Closing the table also cancels the sort. If you want to re-apply a particular sort order, it is a good idea to save it as a named Sort Order (see Sorting using a sort order).
Note: If you have set a Primary Key for your table, canceling a sort returns you to the order imposed by the Primary Key.