N
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.
cheers,
niuginikiwi
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.
cheers,
niuginikiwi