Calculating on a Form

[gumby]

Why does this not work correctly on a form.

=([T1]*1)+([T2]*2)+([T3]*3)+([T4]*4) / [T5]


I do not get the correct answer. What am I doing wrong. I want to be
able to show the avg on the form of several Test Boxes.


Thanks,
David

 

[Richard Williams]

Why does this not work correctly on a form.

=([T1]*1)+([T2]*2)+([T3]*3)+([T4]*4) / [T5]


I do not get the correct answer. What am I doing wrong. I want to be
able to show the avg on the form of several Test Boxes.


Thanks,
David

At the moment you are only dividing ([T4]*4) by [T5]. If your intention is
to divide the whole addition operation then you need to enclose it in
brackets:

=(([T1]*1)+([T2]*2)+([T3]*3)+([T4]*4)) / [T5]