Get sum in field

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

Guest

I have a quick question...I have six values on a form that I need a sum for.
I need the sum to go into one of the other controls on that form. How do I
do this?
 
Make something like this the Control Source property of the Sum text box.
= Nz(text1,0)+Nz(text2,0)+Nz(text3,0)+Nz(text5,0)+Nz(text5,0)+Nz(text6,0)
Change the names to suit.
You need the Nz around each because if no value has been entered, a control
will be null and Null + any number = Null, so you would not see a sum until
all controls have data.
 
Back
Top