The "SortColumn" would be easier to "understand" if it were constructed as:
Val _
(Trim(Str(DatePart("YYYY", [
DateField))) & _
Left("00" & Trim(Str(DatePart("M", [
DateField))), 2))
This will return an un-ambigious VALUE for the year and month, suitable for sorting.
The VAL forces the calulation "Back" to a numeric
The next line returns the 4 digit representation of the year as a string. It NEEDS to be a string to do the simple concatenation with the the thrid line. This will be ~~ "2001".
The thrid line returns the 2 character representation of the month (leading "0" as necessary from the left 2 of hte "00" and the month INTETGER). This part will be ~~ "01" ... "12"
The concatenation will always produce a six character string in the form of "yyyymm".
The Val will force this back to a number.
You can also achieve this result with:
Val(Format([
DateField, "yyyymm"

, but the explination isn't nearly as 'informative'.
MichaelRed
redmsp@erols.com
There is never time to do it right but there is always time to do it over