Displaying digits after the decimal point

A

Amanda

In my table I have a field for quantity. I have the fieldsize set to double
and the decimal places set to 2. However it always rounds to a whole number.
For example when I put in 1.25 it rounds to 1....how can I make it display
the decimal points?
 
D

Douglas J. Steele

When you set the Data Type to Number, the default Field Size (bottom
left-hand corner) is set to Long Integer. Long Integers cannot hold decimal
values. Change the field size to Single or Double.
 
D

Daniel Pineault

Does this happen when you are entering your value using a form or directly in
the table?
 
A

Amanda

It happens in both instances, whether I enter it through a form or through
the table it still does this.
 
D

Dale Fye

Have you checked the Format property?

What happens when you change it to a Decimal rather than Double data type?

--
Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.
 

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

Similar Threads

Access keeps rounding down... Decimal 5
decimal places in a table 1
decimal places 5
Prevent storing more than 2 decimal places 4
Currency column rounding up or down 2
Access stripping decimal places in query 1
Form Combo incorrectly rounding 1
formula for decimal point 4

Top