How to Work Around Table and View Sort Limitations
When you save a table or view, the local sort order is lost. If you want to display a datasheet with a saved sort order, you can either save the table or view as a form datasheet and then sort the records, or save the table or view as a stored procedure with an ORDER BY clause.
Save the table or view as a form datasheet
In the Database window, click Tables or Views under Objects, and then select the table or view you want to save as a form datasheet.
Click the arrow next to the New Object button on the toolbar, and then click AutoForm to quickly create a form.
Switch to Design view.
Make sure the form is selected and then click the Properties button.
Click the Format tab, and then set the DefaultView property to Datasheet.
Switch to Datasheet view.
Do one of the following:
To sort in ascending order, click the SortAscending button.
To sort in descending order, click the SortDescending button.
Save your form datasheet.
Save the table or view as a stored procedure with an ORDER BY clause
If the object you want to save is a view, go to step 5. If the object is a table, do the following:
In the Database window, click Tables under Objects, and then select the table you want to save as a view.
Click the arrow next to the New Object button on the toolbar and then click View to create a view in the Query Designer.
Select all the columns in the field list.
Save your view.
Copy the SQL statement from the SQL pane of the Query Designer, paste it into a stored procedure, and add an ORDER BY clause. To see a demonstration, click the Start button:
