You might consider looking into using the DATAPART function and summing and averaging on the WEEK datepart.
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP