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.