G
Guest
I have a form used to grade each record on 5 criteria. Each criteria can
have a High =3, Moderate =2, or Low=1. The value shown on the form is the
text (high, moderate, low), but the actual value stored in the database is
the numeric value. I want the user to be able to see an average of their
grade on the form once they have graded all categories. I tried the
following:
([combo11]+[combo18]+[combo16]+[combo22]+[combo25])/5
I can't seem to get the average to come out correctly. Also when I just try
to add the fields i.e. [combo11]+[combo18], I get the values concatenated
rather than summed. Can someone help me with the syntax here. Thanks.
have a High =3, Moderate =2, or Low=1. The value shown on the form is the
text (high, moderate, low), but the actual value stored in the database is
the numeric value. I want the user to be able to see an average of their
grade on the form once they have graded all categories. I tried the
following:
([combo11]+[combo18]+[combo16]+[combo22]+[combo25])/5
I can't seem to get the average to come out correctly. Also when I just try
to add the fields i.e. [combo11]+[combo18], I get the values concatenated
rather than summed. Can someone help me with the syntax here. Thanks.