Decimals Places Rounding

[SamDev]

I am using Access 2003. I have set a field to be a percent with two decimal
places. In the form when I input 10 (aka 10%) it comes up as 1000.00% so I
input instead 0.1 and it comes up as 0.00% versus 10%. I multiply this
percent field times a subtotal field to get a discount rate. Problem is
Access is reading the percent field as 0 and returning a zero value to the
discounted field.

I have tried to change the format of the percent field to simply a number
with two decimal places but again when I enter .1 it returns zero.

Any ideas - much thanks!

 

[fredg]

I am using Access 2003. I have set a field to be a percent with two decimal
places. In the form when I input 10 (aka 10%) it comes up as 1000.00% so I
input instead 0.1 and it comes up as 0.00% versus 10%. I multiply this
percent field times a subtotal field to get a discount rate. Problem is
Access is reading the percent field as 0 and returning a zero value to the
discounted field.

I have tried to change the format of the percent field to simply a number
with two decimal places but again when I enter .1 it returns zero.

Any ideas - much thanks!

The field datatype is Long or Inteter.
By definition, an Integer is a whole number (no decimal value).
Change the Field datatype to Double.

 

[SamDev]

Much thanks - one of those "dah, why didn't I think of that?"