access datatypes

[esthera]

I have a field that stores a number. In access I made type number and fieldsize decimal. When I enter in a number (through asp) like 4.5 it automatically puts it in as a 4. What's the trick to keep the decimal part of the number?

[russell]

you have to tell access how many decimal places. go to design view, and look at the properties.

[esthera]

I set it to decimal with 2 places and it still automatically shows it without any decimal?

[russell]

Lets see your code. Are you casting it in your client code? For example

clng(1.22) = 1

???

[esthera]

problem is even in access. -- If i put in a 3.5 (and it is set as number -- decimal with one decimal place) -- I only see a 3.

[russell]

In design view, make sure the data type is number. At the bottom, in field properties, set the field size to double.

[esthera]

that's exactly what it is??

[russell]

you specified double? And then set the decimal places? what version of access?

[russell]

can you posta screen shot of your design view?

[esthera]

whoops.. just realized I did decimal and not double.

Thanks for your help.

[russell]

Glad to help. :)