tough one

[1234adam]

undefinedundefinedundefined


I have a problem. I want to create a query that has some complicated calculations. One of my fields i want to be an average. This average is a 4 week average based off of the prior 4 weeks. The weeks are just monday through friday. So in a given week the average would be the same for the whole week. How do i do this. What i was thinking was to some how get the monday and then get an average of the 20 records before that. In the final result I would like to see Every date that i have on my table along with the average for each day. I just can not come up with a way to do this.

If any one could help i would greatly appreciate it.

 

[Cruz]

Have you tried summing all of the days and dividing it by the total number of days? that would give you an overall average which is the same thing!

 

[1234adam]

I have several years of data. I don't want the average of the all the data. On a given day, the average for that day is the average of the prior four weeks.