How to add up text fields in a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 6 text fields in a report in the report footer. The text fields state
a number. I want to put a new text field in the report footer that adds up
all of the 6 text fields. How do I do this?

thanks!
 
Try a control source of
=Val(txtOne) + Val(txtTwo)+Val(txtThree)...
If your text fields might be Null, you may need to wrap the fields inside
Nz() first.
 
Back
Top