Next question on summing!

  • Thread starter Thread starter clueless
  • Start date Start date
C

clueless

After using the following formula...

=Nz([Value 1], 0) + Nz([Value 2], 0) + Nz([Value 3], 0)

.... I am getting the values of "Value 1, Value 2, and
Value 3" placed in order in the final field...Not summed!
What can I do to get them added up and have the answer
placed in the "final field"???
 
If the fields are defined as text strings, rather than numerics, this will
happen. You will have to explicitly convert the fields to numerics first:

Dim num1 as double

num1 = Cdbl(Nz([Value 1],0)

etc

then

Result = num1 + num2 + num3


--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
 

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

Access #Error & Excel Pivot 0
Can't set the null or "" text box to be a calculable text box 0
Summing the value of 3 fields in Forms 2
sum of two fields in a form 2
Can't get debug to break 1
Adding a continuous form 7
Help with an expression to calculate a profit from one of three fi 2
Adding Multiple Fields 5

Back
Top