Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MS Access - MS Access graph help?

Status
Not open for further replies.

surad

Technical User
Mar 10, 2003
37
US

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"))) AS Dates, ((Avg([P&C].[%
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"))), (Year([Date])*CLng(54)+DatePart
("ww",[Date],0)-1);


Thanks in advance


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top