K
KingsWay
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
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