calculating averages based upon past 30 days

[smithrd6]

How to create query to calbculate moving averages over past 30 days. For any given day within past 30 days,the query should indicate the averages for that day.

 

[alansidman]

Two queries. First one will be to determine the date range.
The second one will be based on the first query and will be an aggregate query using the Average function from the Aggregate Options.

Alan

 

[cjcobra]

I used this code in my Criteria to pull the dates from the previous week. You'll have to add the rest, but it will by dynamic looking at the current date.

Date()-Weekday(Date())-5 Or Date()-Weekday(Date())-4 Or Date()-Weekday(Date())-3 Or Date()-Weekday(Date())-2 Or Date()-Weekday(Date())-1