Average by Week

[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

 

[Jeff Boyce]

Consider doing all that calculation in a query, before you ever get to the
report...