Decimals Places Rounding

  • Thread starter Thread starter SamDev
  • Start date Start date
S

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!
 
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!
Click to expand...


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