Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Jul 2001
    Location
    NJ, USA
    Posts
    617
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Charts, ordering months correctly (Access 2002)

    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

  2. #2
    Star Lounger
    Join Date
    Nov 2001
    Posts
    75
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Charts, ordering months correctly (Access 2002)

    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

  3. #3
    5 Star Lounger
    Join Date
    Jul 2001
    Location
    NJ, USA
    Posts
    617
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Charts, ordering months correctly (Access 2002)

    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

  4. #4
    Star Lounger
    Join Date
    Nov 2001
    Posts
    75
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Charts, ordering months correctly (Access 2002)

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •