ordering data in a report using access 97

  • Thread starter Thread starter wayne zabel
  • Start date Start date
W

wayne zabel

I have a report I developed using the chart wizard. Everything works but I
can't seem to get the data to apear in the order I want on the x axis. My y
axis is quantity, the x axis is year and month. The time period can run
over 18 months. I would like to get the data to appear in the proper year
and month sequence.
My underlying query contains:
the year as Format([Order Detail]![Date Shipped],"yy")
the month as Month([Order Detail]![Date Shipped]). The value I am using for
the x axis is:
Format([Order Detail]![Date Shipped],"yy"" '""mmm")

All suggestions will be greatly appreciated.
 
wayne said:
I have a report I developed using the chart wizard. Everything works
but I can't seem to get the data to apear in the order I want on the
x axis. My y axis is quantity, the x axis is year and month. The
time period can run over 18 months. I would like to get the data to
appear in the proper year and month sequence.
My underlying query contains:
the year as Format([Order Detail]![Date Shipped],"yy")
the month as Month([Order Detail]![Date Shipped]). The value I am
using for the x axis is:
Format([Order Detail]![Date Shipped],"yy"" '""mmm")

All suggestions will be greatly appreciated.
Click to expand...

Anytime you use the Format() function you no longer have a date, you have a
string. If you want chronological sorting you have to use a string format that
will sort alphabetically and also be chronological. YYYY-MM would work.
 
Thanks Rick for the fast reply. I tried it and it does exactly what I want.
Thanks again.
Wayne
 
Back
Top