Sort by Month Order

[sk88]

I have a report that is based on crosstab queries. The 'Month' is what I selected as 'Group on'. My reports looks fine but just need one minor change. Right now it comes up as 'December, March, January' and not in order. How do I make it to appear as 'January, March, December'?



Thanks in advance.

[JoeM]

You will need to use a Numeric or Date field to get it to sort properly. As it is now, it is a Text field, so it is sorting alphabetically.
You could use month number (1,2,3,...) or use a date field. You can format your date field to just show the Month part (you can use the Format property, but don't use the Format function, as that will convert the value to Text!).