One or more field names on which the Recordset is sorted, and whether each field is sorted in ascending or descending order
PROPERTY Sort AS STRING
STRING a String of field names in the Recordset to sort on
Returns a String of field names in the Recordset to sort on. Each name is separated by a comma, and is optionally followed by a blank and the keyword, ASC, which sorts the field in ascending order, or DESC, which sorts the field in descending order. By default, if no keyword is specified, the field is sorted in ascending order
This property requires the CursorLocation property to be set to adUseClient. A temporary index will be created for each field specified in the Sort property if an index does not already exist.
The sort operation is efficient because data is not physically rearranged, but is simply accessed in the order specified by the index.