K
KingsWay
I am trying to average mulitple fields (52 to be exact) and the query won't
calculate them for me. I am trying to average attendance records for each
year. This is my expression:
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)
Thanks for any help you can give me,
Michaela
calculate them for me. I am trying to average attendance records for each
year. This is my expression:
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)
Thanks for any help you can give me,
Michaela