 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / December 2007Decimal houses
Hello everyone, How can I set up Access to consider more than 4 decimal houses? I have tried to do this through property both in the tables and in forms, but it doesn't seem to work. Thanks in advance! Do you mean 'decimal places'? What kind of number are you using? Try changing to Double.  SignatureKARL DEWEY Build a little - Test a little > Hello everyone, > [quoted text clipped - 3 lines] > > Thanks in advance! >Hello everyone, > [quoted text clipped - 3 lines] > >Thanks in advance! I'm struggling to understand what you mean by "decimal houses". Might this be a bad translation? Decimal places perhaps? What datatype are you using? What are some examples of values that you would like to see and cannot? Just for reference: the default Number field is Long Integer, which allows only whole number, no decimals. A Currency datatype allows exactly four decimals, no more, no fewer. A Single Float number allows approximately seven digits of precision - i.e. 1233211.0 or 0.1233211 but not 1233211.1123456. A Double float allows approximately fourteen digits precision. Both Single and Double suffer "roundoff error" (for instance, 1.0 + 2.0 + 3.0 - 6.0 might not be 0.0 but rather 0.000000000000023). The Decimal datatype, available in AccessXP and later, lets you specify the precision and number of decimals, and may be your best choice. John W. Vinson [MVP] Hello John, Literal translations don't always work... I did mean decimal places. I'm using currency. How can I switch to this "double float"? Cheers. > >Hello everyone, > > [quoted text clipped - 22 lines] > > John W. Vinson [MVP] Thanks just changed currency to Number double and it worked!!!! > >Hello everyone, > > [quoted text clipped - 22 lines] > > John W. Vinson [MVP] >Thanks just changed currency to Number double and it worked!!!! Just be aware that Double *is an approximation*. If you will be calculating balances, subtracting numbers, don't forget that you may have differences in the 14th digit of precision. Just for an example: in the Immediate window type ?.1+.2+.3-.6 The result should be 0.0; in fact it is 2.77555756156289E-17. John W. Vinson [MVP] Decimal houses??? If you are talking about the Dewey classification system, then you will be better served by using a text field than a numerical field. SignatureSylvain Lafontaine, ing. MVP - Technologies Virtual-PC E-mail: sylvain aei ca (fill the blanks, no spam please) > Hello everyone, > [quoted text clipped - 3 lines] > > Thanks in advance! |
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.