Help Please Sum Values in A Continous Form

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

Hello

I am having a problem in summing a set of values in a form
My fields are UPC, Qty and NettT against each ordered
product
I can get the line NettT by making the Control =[Qty]*
[UPC]

But when I try to total the NettT fields I keep getting
#Error
=(Sum[NettT])

Where am I going wrong ?

Any help would be greatly appreciated

thanks

Jim
 
Jim,
You can't sum an "unbound" calculated field in a continuous subform
footer, or report footer for that matter..
For simplicity sake, use the Query Design Grid, and create a field in the
query behind the subform like this...
NettT : [Qty] * [UPC]
Now, NettT is a "bound" field, it can be placed on the subform just like
a regular table field, and can be summed in the footer with...
= Sum([NettT])
(Same for report group/report footer toals)
hth
Al Camp
 
Hello

I am having a problem in summing a set of values in a form
My fields are UPC, Qty and NettT against each ordered
product
I can get the line NettT by making the Control =[Qty]*
[UPC]

But when I try to total the NettT fields I keep getting
#Error
=(Sum[NettT])

Where am I going wrong ?
Click to expand...

Two possibilities:

1. The textbox with the Sum() expression should be in the Form Footer,
not in the detail section
2. You cannot Sum a *textbox* - you can only Sum a *field* in the
Form's Recordsource. Either put the [Qty]*[UPC] expression in a
calculated field in the Form's Recordsource query, or recapitulate the
calculation in the Sum:

=Sum([Qty]*[UPC])

John W. Vinson[MVP]
 
Back
Top