Summing Control Vals

  • Thread starter Thread starter Syd
  • Start date Start date
S

Syd

I have this control named txtTots which contains a
calculated value of fields =[A]-. Now I'd like to do a
running sum or get a total which will sum on that field at
the next level (section footer) equal to =Sum(nz
([txtTots])). But, I keep geting an error/parameter
of "txtTots". Is the a way to sum on a calculated
control/field at the report level?

Any ideas welcome....

Thanks,
 
Syd said:
I have this control named txtTots which contains a
calculated value of fields =[A]-. Now I'd like to do a
running sum or get a total which will sum on that field at
the next level (section footer) equal to =Sum(nz
([txtTots])). But, I keep geting an error/parameter
of "txtTots". Is the a way to sum on a calculated
control/field at the report level?
Click to expand...


=Sum(Nz([A]-,0))
 
Rick:

I'm sorry, if I was not clear enough. I need to do a
summing on the control "txtTots" at the second section
footer level. txtTots has the calculated value of
control's [A]- within it in/at the first footer level.

Now, I'd like to take it to next section footer level and
do a sort of running sum on the "txtTots" control which is
in the first footer level via a reference to the "txtTots"
control. Is there a way to do this easily?


-----Original Message-----
I have this control named txtTots which contains a
calculated value of fields =[A]-. Now I'd like to do a
running sum or get a total which will sum on that field at
the next level (section footer) equal to =Sum(nz
([txtTots])). But, I keep geting an error/parameter
of "txtTots". Is the a way to sum on a calculated
control/field at the report level?
Click to expand...


=Sum(Nz([A]-,0))



--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com


.
Click to expand...
 
Syd said:
Rick:

I'm sorry, if I was not clear enough. I need to do a
summing on the control "txtTots" at the second section
footer level. txtTots has the calculated value of
control's [A]- within it in/at the first footer level.

Now, I'd like to take it to next section footer level and
do a sort of running sum on the "txtTots" control which is
in the first footer level via a reference to the "txtTots"
control. Is there a way to do this easily?
Click to expand...


That is what my expression would do. You don't perform aggregations on
controls. You perform them on Fields and/or Expressions.

If I have...

=[A]+

....in the detail section and...

=Sum([A]+)

....in the report footer, the second control will display the total by
virtue of its placement in the footer.
 
Rick:

Thanks,


-----Original Message-----
Rick:

I'm sorry, if I was not clear enough. I need to do a
summing on the control "txtTots" at the second section
footer level. txtTots has the calculated value of
control's [A]- within it in/at the first footer level.

Now, I'd like to take it to next section footer level and
do a sort of running sum on the "txtTots" control which is
in the first footer level via a reference to the "txtTots"
control. Is there a way to do this easily?
Click to expand...


That is what my expression would do. You don't perform aggregations on
controls. You perform them on Fields and/or Expressions.

If I have...

=[A]+

....in the detail section and...

=Sum([A]+)

....in the report footer, the second control will display the total by
virtue of its placement in the footer.


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com


.
Click to expand...
 
Back
Top