Frank Freese
asked on
query to average weekly data
Experts,
I'm trying to create a date parameter query for a line chart that:
1) Based upon the date range create a line chart for each week ending on a Friday where it returns an average for the week. For example, a date range of 6/1/08 - 6/30/08 would return the following:
06/08/08 750
06/13/08 655
06/20/08 600
06/27/08 825
I started with this:
SELECT tblGrossStrokesPerHour.GSP HDate, tblGrossStrokesPerHour.Gro ssStrokesP erHour, tblGrossStrokesPerHour.Lin eCode
FROM tblGrossStrokesPerHour
WHERE (((tblGrossStrokesPerHour. GSPHDate) Between [Start Date] And [End Date]) AND ((tblGrossStrokesPerHour.L ineCode)=8 ))
ORDER BY tblGrossStrokesPerHour.GSP HDate;
I attached the a database
gsph.zip
I'm trying to create a date parameter query for a line chart that:
1) Based upon the date range create a line chart for each week ending on a Friday where it returns an average for the week. For example, a date range of 6/1/08 - 6/30/08 would return the following:
06/08/08 750
06/13/08 655
06/20/08 600
06/27/08 825
I started with this:
SELECT tblGrossStrokesPerHour.GSP
FROM tblGrossStrokesPerHour
WHERE (((tblGrossStrokesPerHour.
ORDER BY tblGrossStrokesPerHour.GSP
I attached the a database
gsph.zip
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER