Need help sorting months

[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"??

 

[Duane Hookom]

Why didn't you reply to my reply? Why did you start a new thread?

 

[Granny Spitz via AccessMonster.com]

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"??

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