Not quite so simple

[Mick]

Something so simple is not working, I need a hint please.
Im trying to add up some field values with
<%dtcosthiresubtotal=dtcosthireitem1 + dtcosthireitem2 + dtcosthireitem3 %>
if dtcosthireitem1, 2, and 3 have values for example 12,26,34, then
dtcosthiresubtotal shows 122634 in a string rather than adding the values to
a total of 72, any clues please.

 

[Ronx]

Convert the variables to numbers before performing the addition.

First check that the variables are actually numeric values
Convert to numbers
Do the sums

<%
If isnumeric(dtcosthireitem1) and isnumeric(dtcosthireitem2) and
isnumeric(dtcosthireitem3) then
Dtcosthiresubtotal = CDbl(dtcosthireitem1) + CDbl(dtcosthireitem2) +
CDbl(dtcosthireitem3)
Else
'Give an error message
End if
%>

 

[Mick]

Hi Ron, spot on answer absolutely cracking, worked first time, many thanks
Mick