adding a decimal to a recordset

[MikeT]

rs("myNumber&quot=rs("myNumber&quot+.2

If i put a whole number in place of .2, it works fine.
The field in the database is setup decimal, but when I use .2 I get a type mismatch error.

Any Ideas?

 

[Mighty]

Try converting the whole number to a double before you submit it:

Dim myNumber

myNumber = cDbl(rs("mynumber&quot + 0.2) Mise Le Meas,

Mighty

 

[MikeT]

Thanks for the tip; I had to tweak it a bit to get it to work though:
temp=cdbl(rs("myNumber&quot)
temp=temp+.2
rs("myNumber&quot=temp

Whatever works I guess...