summing muitliable text boxes

  • Thread starter Thread starter don
  • Start date Start date
D

don

hi

i have a report that returns a value in several text boxes
in several different records. my problem is i can get a
sum in the report footer for one text box but i would like
to return the sum of all the text boxed in one box. is
there a way to do this? i could do a sum for each text box
and the add them but it seems there could be an easier way.

thanks
 
don said:
i have a report that returns a value in several text boxes
in several different records. my problem is i can get a
sum in the report footer for one text box but i would like
to return the sum of all the text boxed in one box. is
there a way to do this? i could do a sum for each text box
and the add them but it seems there could be an easier way.
Click to expand...


That's probaly the most straightforward way to do it.

=Sum(field1) + Sum(field2) + . . .

If you prefer it, the mathematically equivalent should also
work.

=Sum(field1 + field2 + . . .)

but if some of the fields are Null, the latterwill probably
not be what you want.
 
hey marsh

i tried your suggestion and it did what you said if the
box had a zero.

i did figure it out tho
fyi

i created a hidden footer after each record and put the
formula =Sum(field1) + Sum(field2) + . . .
and changed the running sum to over all it worked fine
there even with zero in some of the boxes it would add
each record.

then created a text box in the report footer and returned
the above textbox from the hidden footer.

thanks for your help.

don
 
Back
Top