numbers driving me mad 1

[andyc209]

I have 3 values from a query

value1 = 1000.50
value2 = 200
value3 = 50

if I add them together instead of getting 1250 i keep getting 100020050.I assume this is to do with numeric / string stuff. how can i get them to add to 1250 whilst retaining 2 decimal places as sometimes value1 may be 1000.40.

 

[gmmastros]

There are a couple ways, but they all involve converting your value to a number.

You could do this...

cSng(Value1) + cSng(Value2) + cSng(Value3)

This will convert your string values to the single data type prior to doing the addition. Alternatively...

Val(Value1) + Val(Value2) + Val(Value3)

Either way, you need to convert to a number first.


-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[andyc209]

thanks for this, seems to work, cheers.

 

[alex5935]

you can try cdouble(val) or cint(val) I am not so sure, but it is might work.