Changing the Order of Queried Rows
You can set an ORDER BY clause on the query by clicking the Query tab of the view object editor. To invoke the Edit Query dialog box, click Edit (pencil icon) in the Query section of the panel. Enter an ORDER BY clause (without the ORDER_BY keyword). If you click Edit to the right of the Order By field, you invoke a dialog box that enables you to select the columns and construct the ORDER BY clause.