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