calculating a SUM function in a form

  • Thread starter Thread starter Benjamin Piercy
  • Start date Start date
B

Benjamin Piercy

Dear all,
I am producing a subform within a form which shows a
candidates grades. With the use of a query, IF functions
then help calculate the points from these grades, e.g.
grade A= 120 points, B= 100 points and so on....
I therefore have a list of subjects, grades and points
for each student within the subform and this works.
I am now trying to introduce a sum function to add the
points displaying a total points field in the subform. i
cant get round it no matter what i try!!! Does the
expression need to be made in the form or the query,
which the subform is based on...?
Any help would be greatly appreciated
Benjamin Piercy
 
If I understand correctly, the main form is the student, the subform has the
subjects, grades, points, etc. Put a textbox on the subform footer that
performs your sums. On the main form, create a textbox and add the
following expression:

=[subformname].Form!textboxname

This refers to the textbox on your subform footer.

HTH
Damon
 
Back
Top