Q. Sort Asc for Week Numbers on Chart

[niuginikiwi]

Hi all,
I have a report that has a chart of line graph graphing sales of a
certain prodouct over several weeks of the year and that has a query
as row source.
On the horizontal (x) axis I have a data table with one of the two
horizontal rows as week numbers. In the query I have used Format$
(OrderDate,"ww") to get the week numbers... and this week numbers are
on that horizontal row.

Whats happening is the numbers appearl like this 1, 10, 11, 12,etc,
2, 20, 21, etc, 3, 30, etc but I want it to appear as it is in the
date order of the OrderDate field. such as 1, 2, 3, 4, 5, 6,.... 10,
11, 12,.... 20, 21, 21, ... etc...


Does anyone know a why around to get them to appear in the order they
are as in the date order of field OrderDate.
I have spen over an hour playing around trying to get it sorted but I
can not.
Any help would be well appreciated.

 

[Duane Hookom]

One method is to use
Format$(DatePart("ww", OrderDate),"00")
Another method is to change the Row Source of the chart to sort by the week
number.

 

[niuginikiwi]

Thanks Duane,
The first method worked to my need so I am comfortable with that for now.
Thanks for the help.