SUM in a Continuous form

[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.

 

[Ken Snell \(MVP\)]

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])

 

[Guest]

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

 

[Ken Snell \(MVP\)]

Then put that whole expression in the Sum function:

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