SUM in a Continuous form

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

Guest

Hi, I have a continuous form with a calculated textBox in the form detail
(T1Calories), I want to create a textbox in the header (TotalCalories) to sum
all the amount of (T1Calories) what I did was to put this instruction
=Sum([T1Calories]) in the control Source of TotalCalories but I doesn't work.

If somebody can help me I would appreciated.
 
You must use the name of a field in the Sum function, you cannot use the
name of a control. So, use the Control Source name from T1Calories textbox
in the Sum function:

=Sum([NameOfField])
 
Hi Ken,

The problem is that T1Calories is a calculated field I have this formula
=([MealQuantity]*[Calories])/[MesurementQuantity] in the control source of
T1Calories

Thanks
 
Then put that whole expression in the Sum function:

=Sum(([MealQuantity]*[Calories])/[MesurementQuantity] )
 

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

Add 2 calculated fields 4
Sum If function in textbox 0
Continuous Forms - Sum of Values 5
Running Total from a Subform 1
Calculations on a Continuous Form 6
Summing field in Subform 6
Sum() 5
Summing in a form! 1

Back
Top