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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum If function in textbox 0
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Access Daily Entry with multiple entries per field 0
Summing a complex formula 1
Assigning a calculated txtbx value to a field in the associated ta 4
Sum() 5
Add a Calculated control that displays the total sum of two fields 6
Calculated Fields 4

Back
Top