How do I add up a column in a subform?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Hi

If you are trying to count the number of records you could use
=count([FieldName])
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Displaying a subform total in a form 5
PROBLEM: Subform total on main form returns #Name 5
Adding two subtotals together. 2
Delay in getting subform total to calculate 2
Subform Totals 4
Unremovable horizontal scroll bar on subform 1
Best way to calc total on a form from a bunch of subforms 3
Total in a subform 1

Back
Top