Access Charts and Dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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???
 
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.
 
Back
Top