Delete a sort (MDB)

• Click Remove Filter/Sort on the Records menu.

Note  If you specified the sort order in the Advanced Filter/Sort window where you also specified criteria for a filter, you can delete the sort order in the Sort cell in the design grid and still leave the filter's criteria intact.

1. Open the report in Design view, or if the report is already open, make sure it is selected in the Database window.
2. Click Properties on the Report Design toolbar to display the report's property sheet.
3. In the OrderByOn property box, click No to remove the sort order.

Note  If you specify a sort order in a report wizard or in the Sorting And Grouping dialog box in report Design view, that sort order overrides the inherited sort order.