Sorting months (not alphabetically)

[labbadabba]

I have a series of subforms that show customer mix percentages by month. These forms will be used for data entry and to ease the process I would like to have months in order of our fiscal calendar, July through June. Right now the months are listed alphabetically. Is there a way I can list the months in order without having to resort to a naming convention such as:

01June
02August
03September
ect.

Thanks

 

[labbadabba]

Nevermind

Nevermind, I just created a field in the query that put my months in order.

Thanks Anyway.