Specifies one or more field names the Recordset is sorted on, and whether each field is sorted in ascending or descending order.
Settings and Return Values
Sets or returns a String of comma-separated field names to sort on, where each name is a Field in the Recordset, and is optionally followed by a blank and the keyword ASCENDING or DESCENDING, which specifies the field sort order.
Remarks
The data is not physically rearranged, but is simply accessed in the sorted order.
A temporary index will be created for each field specified in the Sort property if the CursorLocation property is set to adUseClient and an index does not already exist.
Setting the Sort property to an empty string will reset the rows to their original order and delete temporary indexes. Existing indexes will not be deleted.