Category Axis on Chart

[Guest]

Hi folks,

I have a chart in Access that charts daily traffic based on each month. My
question is that in the datasheet view I have it set up for Jan,Feb,Mar etc..
When the report runs in print preview the months are in alphabetical order
rather then Jan, Feb, Mar. It displays Apr, Aug, Feb how do I correct this ?

Thanks in advance.

 

[Duane Hookom]

Modify the Row Source property of your Chart control to put the months in
month number order. If you can't figure this out, come back with your Row
Source sql view.