how to calculate avarege mark, using form 1 for test 1,form2 for test 2 and form3 for test 3 and the avg needs to be displayed in form 4. The mark must be inputed in the textboxs on the forms.

how to calculate avarege mark, using form 1 for test 1,form2  for test 2 and form3 for test 3 and the avg needs to be displayed in form 4.
The mark must be inputed in the textboxs on the forms.
jiko MaloveAsked:
Who is Participating?
 
John TsioumprisConnect With a Mentor Software & Systems EngineerCommented:
use the Expression Builder for each of the controls to refer to value1,value2,value3 ....sum them and then divide them to the number ot arguments to get the average for form's 4 average textbox ControlSource
=([Form1].Form![Value1]+[Form2].Form![Value2]+[Form3].Form![Value3])/3

Open in new window

0
 
Martin LissOlder than dirtCommented:
Jiko, please attach your workbook.
0
 
John TsioumprisSoftware & Systems EngineerCommented:
Solution provided
0
All Courses

From novice to tech pro — start learning today.