About Working Around Table and View Sort Limitations
Although sorting tables and views is limited compared to other database objects, you can work around these limitations by saving the table or view as another object and then sorting the records. For example, you can:
Save the table or view as a form datasheet and then sort the datasheet.
Save the table or view as a stored procedure with an ORDER BY clause.
