Need help sorting months

  • Thread starter Thread starter KK
  • Start date Start date
K

KK

I have a table which has a field called "Time Period". In these fields,
there are a bunch of months ie. January, February etc.

How can I sort it so that when I create a combo box that pulls up
distinct Time Period values, it shows up as "January, February, April,
June" instead of "April, February, January, June"??
 
KK said:
How can I sort it so that when I create a combo box that pulls up
distinct Time Period values, it shows up as "January, February, April,
June" instead of "April, February, January, June"??
Click to expand...

SELECT MoName, CInt(Format(CDate(MoName & "-1-2006"), "m")) AS Mo
FROM tblMonthNames
ORDER BY 2;
 
Back
Top