Average by Week

  • Thread starter Thread starter xeb
  • Start date Start date
X

xeb

Hi:

I'm using an "IIf" statement in a report to return average
calculations for each day of the week. In other words, my report ha
five expressions, one for each weekday, that shows averaged data fo
that weekday.

Now I want to do the same thing for weeks, using "ww" I guess.

My fields are as follows:

Date
1
2
3
Etc.

What would the expression for this be?

Thanks,

xe
 
Back
Top