displaying the months on a graph by fiscal year not calendar year

S

SMT

I have a query in which I have included the tblmonth, which has a number and
its corresponding month according to fiscal year...i.e.,
Month, MonthID
October, 1
Novemer, 2
December, 3 and so on.

I am creating chart off of this query and need the chart to show display the
actual month but sort it in the order of MonthID. For example my graph has
the months listed at the bottom but they go in alpha order versus fiscal year
order which is what I need. How can I correct this so the graph will display
the appropriate month in its appropriate order?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

select dates for last fiscal year 3
Fiscal year (another try) 6
Group by fiscal months 5
How to chart months by financial year 0
Calculating YTD totals on a Fiscal Year 7
YTD for the fiscal year 5
Tracking annual training when my fiscal year starts October 1st 3
Update To line in a Query -- incorrect results!! 4

Top