SQLRequest.OrderBy (gb.db)

Function OrderBy ( OrderBy As Variant, ... ) As SQLRequest

Describe the ORDER BY clause of the request.

The arguments describe the ORDER BY fields. You can specify either one field name by argument, or all field names in a single argument, as a String array.

The current request is returned so that you can chain method calls.

You can specify that a field must be sorted in descending order by adding a space and the "DESC" string after the field name.