Group by "Month"

[kwooten]

I am trying to group by month. My query table is named pay_per which is where the report is getting data. When I group by "month" it puts April first. How can I make the report realize "pay_per" is month format and January should be first?

[NTC]

ah - well blame this on those crazy humans that don't alphabetize their months correctly.... you need to order by the numerical value of the month, rather than the alpha. How you do that will depend on what how your data is currently organized but probably you have a date field and can pull out just the Month( ) into a calculated field in a query and use if for ordering.....

in report have the grouping on the numerical value - - but also include the Alpha field - - and then make the numerical field not visible.....

Hope it helps.