Averaging with multiple fields

[Guest]

I am trying to find an average for 52 different fields and the query won't
calculate. When I initially set it up, it worked, but after I started
inputting data in the other fields it stopped.

Here is the expression I'm using:

Expr1:
Avg(([wk1]+[wk2]+[wk3]+[wk4]+[wk5]+[wk6]+[wk7]+[wk8]+[wk9]+[wk10]+[wk11]+[wk12]+[wk13]+[wk14]+[wk15]+[wk16]+[wk17]+[wk18]+[wk19]+[wk20]+[wk21]+[wk22]+[wk23]+[wk24]+[wk25]+[wk26]+[wk27]+[wk28]+[wk29]+[wk30]+[wk31]+[wk32]+[wk33]+[wk34]+[wk35]+[wk36]+[wk37]+[wk38]+[wk39]+[wk40]+[wk41]+[wk42]+[wk43]+[wk44]+[wk45]+[wk46]+[wk47]+[wk48]+[wk49]+[wk50]+[wk51]+[wk52])/52)

Any help would be appreciated.
Thanks,
Michaela

 

[Rick B]

Answered in your 8:57 post.

 

[Guest]

sorry about the double post...it didn't verify posting and I couldn't find it
anywhere!!
)

Answered in your 8:57 post.


--
Rick B

I am trying to find an average for 52 different fields and the query won't
calculate. When I initially set it up, it worked, but after I started
inputting data in the other fields it stopped.

Here is the expression I'm using:

Expr1:
Avg(([wk1]+[wk2]+[wk3]+[wk4]+[wk5]+[wk6]+[wk7]+[wk8]+[wk9]+[wk10]+[wk11]+[wk
12]+[wk13]+[wk14]+[wk15]+[wk16]+[wk17]+[wk18]+[wk19]+[wk20]+[wk21]+[wk22]+[w
k23]+[wk24]+[wk25]+[wk26]+[wk27]+[wk28]+[wk29]+[wk30]+[wk31]+[wk32]+[wk33]+[
wk34]+[wk35]+[wk36]+[wk37]+[wk38]+[wk39]+[wk40]+[wk41]+[wk42]+[wk43]+[wk44]+
[wk45]+[wk46]+[wk47]+[wk48]+[wk49]+[wk50]+[wk51]+[wk52])/52)

Any help would be appreciated.
Thanks,
Michaela