How to: Sort Multiple Columns in Queries
You can specify the order in which you want to use the columns to sort the data by using the Sort Order column in the Criteria Pane.
Note
Your computer might show different names or locations for some of the Visual Studio user interface elements in the following instructions. The Visual Studio edition that you have and the settings that you use determine these elements. For more information, see Customizing Development Settings in Visual Studio.
To sort query results by more than one column
In the Criteria pane, click the Sort Order field for the column upon which you want to sort.
Type an integer or select an integer from the drop-down list to indicate this column's place in the order of sorted columns.
Repeat steps for each column by which you want to sort your results.