I'm at work now!!!! attached is a sample of data for ONE day. How can I correct average this!
Here is the query I am using to try to average this...
SELECT Avg(rickdata.[TOTAL ELAPSED TIME]) AS [AvgOfTOTAL ELAPSED TIME], Calendar.week_of_year
FROM rickdata INNER JOIN Calendar ON rickdata.Date...