ordering data in a report using access 97

[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.

 

[Rick Brandt]

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.

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.

 

[wayne zabel]

Thanks Rick for the fast reply. I tried it and it does exactly what I want.
Thanks again.
Wayne