how to get decimal digits without being rounded on forms

B

B®ainstorm

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
 
A

Allen Browne

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.
 
F

fredg

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top