 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Database Design / January 2004Rounding numbers
I have a table with a field called [Rate]. It is formatted as a fixed number with 5 decimal places. Everytime I enter a number, it automatically rounds the number to the next highest or lowest digit. I would like it to not round off. What do I need to do? Thanks Try changing to automatic, instead of fixed, and use an input mask to constrain data entry on the form to 5 digits. >-----Original Message----- >I have a table with a field called [Rate]. It is formatted [quoted text clipped - 4 lines] >Thanks >. >>-----Original Message----- >>I have a table with a field called [Rate]. It is [quoted text clipped - 5 lines] >off. >>What do I need to do? The default Number datatype is a Long Integer - and an Integer, by definition, has no decimal places. Change the datatype of the field to Double. John W. Vinson[MVP] Come for live chats every Tuesday and Thursday http://go.compuserve.com/msdevapps?loc=us&access=public |
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
|
©2008 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.