I have two numbers called from my database
strProductSubTotal = rs("productprice")
strDelivery = rs("delivery")
and I add them later
strSubTotal = strProductSubTotal + strDelivery
but the numbers are not adding
i.e.
strProductSubTotal = 2.50
strDelivery = 0.90
strSubTotal would be calculated as 2.500.90 but I need it to be 3.40
I tried converting the values to numbers using int but 2.50 was being output as 2.00 so the final calculation was 2.90.
How do I convert to a number and retain the decimals?
Thanks
strProductSubTotal = rs("productprice")
strDelivery = rs("delivery")
and I add them later
strSubTotal = strProductSubTotal + strDelivery
but the numbers are not adding
i.e.
strProductSubTotal = 2.50
strDelivery = 0.90
strSubTotal would be calculated as 2.500.90 but I need it to be 3.40
I tried converting the values to numbers using int but 2.50 was being output as 2.00 so the final calculation was 2.90.
How do I convert to a number and retain the decimals?
Thanks