how to get decimal digits without being rounded on forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Between all these "deep" queries and solutions, my problem may be a little to
easy for the most of you to spent time on it, but I hope that someone out
there can help this access beginner not to loose his passion with his first
step.

My input of a standart decimal digit with 2 digits after the comma appears
rounded up. e.g. i am putting in 501,90 but the digit apears as 502. I want
the digits appear as I put them in, without being rounded up.

Thanks a lot for your help. Sincerely, B®ainstorm
 
Open the table in design view.
Select the problem field.
Presumably the data type is Number.
In the lower pane of table design window, the first property is Field Size.
Change it to Double.
The Integer types can handle whole numbers only.

Alternatively, change the data type to Currency if that is a better fit for
your data.
 
Between all these "deep" queries and solutions, my problem may be a little to
easy for the most of you to spent time on it, but I hope that someone out
there can help this access beginner not to loose his passion with his first
step.

My input of a standart decimal digit with 2 digits after the comma appears
rounded up. e.g. i am putting in 501,90 but the digit apears as 502. I want
the digits appear as I put them in, without being rounded up.

Thanks a lot for your help. Sincerely, B®ainstorm
Click to expand...

In most probability, your Field size is Integer or Long Integer.
By definition an integer is a whole number (no decimal portion).
Change the Table Field's field size property to Double.
 
My input of a standartdecimaldigit with 2 digits after the comma appears
rounded up. e.g. i am putting in 501,90 but the digit apears as 502. I want
the digits appear as I put them in, without being rounded up.
Click to expand...

CURRENCY will round at four decimal places using banker's rounding
algorithm. DOUBLE will round to 15 significant figures and is an
approximate numeric type.

My recommendation is to use the DECIMAL type which does not round
(rather it truncates symmetrically at its decimal scale and raises an
exception if its precision is exceeded) and is an exact numeric type.

Jamie.

--
 
Back
Top