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.
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.