All,
I have the following chart where the data comes from an MS Access
query.
The numbers on the X-Axis are week numbers such as 1 (week #1), 2 (week
#2)
, 3 (week #3), ... What I really want to display on the X X-axis is:
1/3/03 (week ending 1/3/03), 1/10/03 (week ending 1/10/03), etc. Also
the
MS Access query SQL that I am currently using is as follows:
SELECT CInt((Format([Date],"ww"
Scheduled]))
*100) AS [% Scheduled], ((Avg([P&C].[% Scheduled Compliance]))*100) AS
[%
Scheduled Compliance], ((Avg([P&C].[% Scheduled Compliance Goal]))*100)
AS
[% Scheduled Compliance Goal]
FROM [qryP&C]
GROUP BY CInt((Format([Date],"ww"
("ww",[Date],0)-1);
Thanks in advance