sorting by month

F

Fons Ponsioen

Since you are only sorting the months and appear not to be
ionterested in dates, I woul create a second table with
the months anf their respective number, than you can
include the table in your query and sort on the month-
number.
Hope this helps.
Fons
-----Original Message-----
I have a form where the use enters a month (Jan, Feb,
etc.) The format for that field in the table is TEXT.
Well, when we run reports it sorts it in alphabetical
order. How can I make it sort by month even though there
is no date format available for abbreviated months??
 
Top