Chart

[Paradigm]

I have a report produced using the chart wizard. It is intended to show a
running (accumulative) cost against month so the bottom axis has months but
since it spans a number of years, it also needs to show years and months.
How can I produce a chart that uses 2 variables on the bottom axis sorted
first by year and then by month?
Alec

 

[OfficeDev18 via AccessMonster.com]

There are several ways to skin the cat. Here's one.

In the report's record source (table or query) add a field that is a STRING
combination of the year and month, such as "200606". In your report, in the
Sorting and Grouping drop-down, use this combo field for the footer section.
You can format it any way you want for display purposes.

Hope this helps.

Sam