Sorting on Months

[CEH]

I don't know if this one should be in "reports" or "queries" not sure where the fix would be. I did a query, employees hours. The report list the name (names) in groups, 4 months, same name four times with the hours for each month.
Now if that makes since heres the problem.
When I sort in the group, the months will only sort aphabetically. August, september, October, and November will not sort in THAT order. Whats the fix?

 

[Mile-O]

Because months are text it will sort them alphabetically. You should, if you don't have it already, calculate a date field in your query and sort on that instead.

 

[snoko]

Create a look up table to hold to months - 2 fields ID (1 to 12) and Month (Jan - Dec) then order the months by ID in the main table. This will give you the correct order.

 

[krunalprajapati]

Ceh

in ur query write down 'order by format(ur datefieldname, "mm")
then run ur report.

 

[krunalprajapati]

Get out of the habit of formatting a date to sort it. Just sort the date field!

SORRY
and Thank u Sir.