 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / January 2008stop automatic rounding
I changed the number format from integer to decimal to stop rounding, but it still does it. When I enter "6.50" the number that shows is "6.00" which throws off calculations! How a number is stored and how it is displayed are two different issues. What it sounds like is that the underlying field in the table is defined as an integer. Integers are whole numbers. The rounding may be happening because Access is treating the number you enter as an integer. Regards Jeff Boyce Microsoft Office/Access MVP >I changed the number format from integer to decimal to stop rounding, but >it > still does it. When I enter "6.50" the number that shows is "6.00" which > throws off calculations! How do I change the underlying field definition? > How a number is stored and how it is displayed are two different issues. > [quoted text clipped - 11 lines] > > still does it. When I enter "6.50" the number that shows is "6.00" which > > throws off calculations! > How do I change the underlying field definition? > [quoted text clipped - 13 lines] >>> still does it. When I enter "6.50" the number that shows is "6.00" which >>> throws off calculations! What is an Integer Format? I believe you are confusing a field's format with it's datatype. Open the Table in design view. In the upper panel, look at the field's datatype property. It should read either Currency (a datatype, which is different from the Currency format) or Number. If the datatype is Currency, the maximum number of decimals you can use is 4. Note: you don't necessarily have to use a Currency datatype with just money fields. You can then set the field's Format property to any valid number format. If it is Number, then look at the Field size property in the lower panel. It should read Double or Single, NOT Integer or Long Integer (by definition, an Integer is a whole number and cannot have a decimal value). You can then set the field's Format (which effects how the number is displayed, not how it is stored) and Decimal Places as needed. Save the changes.  SignatureFred Please respond only to this newsgroup. I do not reply to personal e-mail |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.