How to add up text fields in a report

H

help!

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!
 
D

Duane Hookom

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.
 
Top