Charts, ordering months correctly (Access 2002)

Topic

New Reply

I am working on a chart that was placed on a report using the chart tool that I placed on the toolbox.

The chart uses FullName as row header, Month as column header, and SumOfSumOfLengthofService (Units of service sums) as the value. None are sorted. The chart is based on qryIndMonthlyTotalsHistory which in turn is based on qryIndMonthlylProdStage1. In the qryIndMonthlylProdStage1 there is an expression Month: Format([DateofService],”mmm”) to give me the months and date of service that is sorted in ascending order. In qryIndMonthlyTotalsHistory (or the second query) the months came sorted ascending, without me sorting it. If I put date of service on this query and sort ascending it gives to much data. I then using the chart tool put a chart on a report rptIndividualProductivity linking them with FullName

It works as advertised, except the months are sorted a to z. What I need in Apr, May, Jun, Jul, and Aug not Apr, Aug, Jul, Jun, and May. How do I correct this. I have been looking around and have not found the answer.

Thank you for your time. Fay

Reply | Quote

Replies

What I know about charts you can comfortably put in your eye, but maybe you can you use something like this in your query to sort by month – SortMonth: Month([DateOfService]) and then sort ascending on this column.

I hope this works for you.
Jack

Reply | Quote

I was always told to keep things out of my eye, including charts, fingers, and contacts.

You expression worked well on the query I placed it in front of the original month. When I put it on the report as a chart and used your SortMonth as the column heading it worked great. Now all I have to do is change the labels of 4, 5 etc to April, May etc.

Thank you. Fay

Reply | Quote

Just leave your Format for the Month Names and uncheck the Show button for the column that sorts by the month. In other words, just add the column I suggested and leave everything the way it was before then you should not have to change anything…

Jack

Reply | Quote