writing decimals back to an access database

[roger2282]

help, I am trying to update a field on my database and cant seem to get the right value stored


eg on reading the database field i get the values I need such as 31.24, 3.15 and 16.00 and I use these in the web application successfully but when I come to write these values back to the database I cant write the decimals.

when I write these values back using the code
RecordSet("price") = intprice

I get 16.00 and 3124.00 and 315.00

I have tried changing the field in access to currency, long integer and double to no affect.

[iam_clint]

wrap whatever number your writing back in

cint(123.20)

I believe this is right maybe not if that don't work try

cfloat(123.20)