SUM in a Continuous form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Orlando - 27 May 2007 00:14 GMT

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.

Reply to this Message

Ken Snell (MVP) - 27 May 2007 00:23 GMT

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

Signature

Ken Snell
<MS ACCESS MVP>

> 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
[quoted text clipped - 4 lines]
>
> If somebody can help me I would appreciated.

Reply to this Message

Orlando - 27 May 2007 00:44 GMT

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

Reply to this Message

Ken Snell (MVP) - 27 May 2007 01:10 GMT

Then put that whole expression in the Sum function:

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

Signature

Ken Snell
<MS ACCESS MVP>

> Hi Ken,
>
[quoted text clipped - 3 lines]
>
> Thanks

Reply to this Message