Without a SORT clause or a SAS BY statement, the data order is determined by the Native Key for the CA-DATACOM/DB table (or by the Default Key specified in the access or view descriptor). A SAS BY ...
You don't need a complex set of expressions or even VBA to sort Access date values by specific components, such as month or year. Use DatePart() and sort on its results. When grouping date values at ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results