sort chart bars

[tinoco]

hi!
I'm making charts about the expenses per month.
Each subform is a different chart.
My problem is that the months doesn't appear in right order.
For example the bar of july appears after the bar of august. I tryed to sort the months in the querie but still doesn't work.
Anyone can help me?
Thanks

 

[PHV]

Prefix the monthname with the month numer in the query:
Format(Date,"mm-mmmm") As [Month]

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[SkipVought]

FYI,

This is probably a result of poor table/query design. Instead of storing/querying a STRING (month) it would be better to store/query a DATE and aggregate/format for REPORTING/CHARTING as desired.

Skip,

_{[red]Be advised:[/red] When you ignite a firecracker in a bowl of vanilla, chocolate & strawberry ice cream, you get...
Neopolitan Blownapart!}