Access Charts and Dates

S

SCHNYDES

Hi all, quick question.

I have an access chart, derived from a query. My X axis is grouped by this
field in my query:

format([rate change],"Mmm")

The axis is grouped by it, however it's not in month order, it's
alphabetical. How do I make this access sort by the month Jan-Dec???
 
R

Rick Brandt

SCHNYDES said:
Hi all, quick question.

I have an access chart, derived from a query. My X axis is grouped by this
field in my query:

format([rate change],"Mmm")

The axis is grouped by it, however it's not in month order, it's
alphabetical. How do I make this access sort by the month Jan-Dec???
Click to expand...

The query for the chart needs to also include a column formatted such that a
sort will be identical to a chronological one. An example would be Format([rate
change],"MM").

You can display one and still sort on the other.
 
Top