Re: sorting within a group

Why not just use the to_char to get the month? to_char(mydate,'mmmm') or to_char(mydate,'mm') select to_char(mydate,'mmmm') from mytable where .. order by to_char(mydate,'mm') asc;

Jim

"Michael Sterling" <stermic_at_gw.co.jackson.mo.us> wrote in message news:f7359f44.0306101240.3504aaf2_at_posting.google.com...
> ok, here's the situation. i created a formula for to get the month out
> of this date field. the steps i took are as follows, i first took the
> month from the date field:
>
> Month({occup_main.occupied_date})
>
> this gave me the month in a number form. i.e. 1.00 = january.....12.00
> = december.
>
> then, since i wanted the name of the month to show on the report
> instead of that number i did this:
>
> MonthName(Month({occup_main.occupied_date}))
>
> then i made a group from this formula. the problem is that my records
> are now grouped in the wrong order. in other words, when ever i run my
> report my data is grouped in the alphabetical order of the months. in
> other words..
>
> April
> some records for april
> .
> .
> August
> .
> .
> some records for august
> .
> .
> .
> .
> September
>
> i want to order the months the way are gregorian calender has them
> ordered, january, february, march, april......december. how do i do
> this
Received on Tue Jun 10 2003 - 21:58:17 CDT