Displaying digits after the decimal point

  • Thread starter Thread starter Amanda
  • Start date Start date
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?
 
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.
 
Does this happen when you are entering your value using a form or directly in
the table?
 
It happens in both instances, whether I enter it through a form or through
the table it still does this.
 
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

decimal display 10
Access stripping decimal places in query 1
Decimal displays 1, 2, or None 2
decimals 6
Query Calculation Decimal Point Removal 7
Stop Rounding in Forms 2
Round Up a Decimal 6
Form Combo incorrectly rounding 1

Back
Top