How do I add up a column in a subform?

  • Thread starter Adding a column in a subform?
  • Start date
A

Adding a column in a subform?

In my subform I have a column which I would like to get the total of. I've
managed to make it so I can get the number in the column of the record I have
selected, but not the whole total. The total should appear in a box in the
subform footer and so far the box has the equation
=Sum([NumberOfCandidatesEntered1])
Could anyone help me?
 
W

Wayne-I-M

Hi

If you are trying to count the number of records you could use
=count([FieldName])
 
K

KM Davison

Is you calculated control a text box with the equation in the control source
and located in the form footer, not the detail section, I also find that the
name of the control has to be unque.

Katherine Davison
www.KatherineDavison.co.uk
 
Top