To remove a sort order from a table, query, or form, on the Home tab, in the Sort & Filter group, click Clear All Sorts. This will remove the sort order from all fields in the view.
How do you sort a sort in access?
To sort records:
- Select a field you want to sort by. ...
- Click the Home tab on the Ribbon, and locate the Sort & Filter group.
- Sort the field by selecting the Ascending or Descending command.
- The table will now be sorted by the selected field.
- To save the new sort, click the Save command on the Quick Access Toolbar.
How do I sort dates in Access query?
To do this:
- Click a column header or a cell under a column header for a table or query, or click a control or its accompanying label on a form. ...
- Right-click a column header or a cell under a column header for a table or query, or right-click a control or its accompanying label on a form, and click Sort Newest to Oldest.
