Order By property

Previous Next

This is where you specify the (database) column(s) that determine(s) the order in which records are displayed on the screen.

When specifying more than one column name, separate column names by a soft return, not by a comma. You can type a soft return by pressing SHIFT + ENTER.

To specify the DESCENDING option, use the following syntax:

<columnname> DESC [<columnname> ASC/DESC]

You can also set the ORDER BY clause in the SELECT statement of the Underlying Query property.