Making months in a report go Jan-Dec??

[rubyred77]

I have a report built off a query that shows the monthly totals of sales for each location. At the end of each group of months (the year's months) there is a SUM, and then the next year is listed below that.

How do I change how my months are listed? They appear so randomly. The first year's listing goes Sept, Jan, Dec, Oct, Aug, Jul, Jun, May, Apr etc. and this isn't because September had the most or least amount of sales. Then the next year starts with Novembers' sales, then July, October etc.! So random!

I've gone into the design view and have tried to figure this out by clicking on the 'month' field and going to properties. But nowhere does it let me choose how I want this data listed.

Any thoughts?

 

[ccox]

I'm no Access guru, but I have forced sorts using the following:
You could create a field in your query called Sort and assign numbers to each month. Ex:
Sort: Switch([fieldname]="January",1,[fieldname]="February",2)
Then in the sorting and grouping on your report, sort on the “sort” field in ascending order.

 

[rubyred77]

Thanks a lot CCox.

What I actually ended up doing was adding a 'Date' field to my table and then did a sort on that. This indirectly affected the order of my months as well.

Hope that will help someone!