Pedro Janssen
pedro at plex.nl
Tue Apr 8 13:29:07 CDT 2003
Thanks to all that responded to my question. I think i skipped the college class where they explained how numbers are working on computers. But its good that you folks can explain this to me again. Pedro Janssen ----- Original Message ----- From: "Henry Simpson" <hsimpson88 at hotmail.com> To: <accessd at databaseadvisors.com> Sent: Tuesday, April 08, 2003 5:09 PM Subject: Re: [AccessD] roundup - decimal places > Pedro: > > You are thinking in base 10 so perhaps an example in base 10 will help. > What is the value of 1/3 in base ten to one decimal place and how close is > that to the actual value of 1/3. In base 3 it is an exact value but in base > 10, it is an approximation. Fractional numbers in Base 2 also are a mere > approximation of base 10 numbers. There are numbers like .5, .75, .125, > .375 that are exact number in both base systems, but numbers like .1 can not > be exactly represented as they have an infinite number of decimal places in > base 2 just as 1/3 has an infinite number of decimal places in base 10. > > Hen > > > > > >From: "Pedro Janssen" <pedro at plex.nl> > >Reply-To: accessd at databaseadvisors.com > >To: <accessd at databaseadvisors.com> > >Subject: Re: [AccessD] roundup - decimal places > >Date: Tue, 8 Apr 2003 13:16:21 +0200 > > > >Hello Charles, > > > >I use single as datatyping. > >Here are a few values that i received as result: > > > >2,199998 > >0,2000008 > >0,2999992 > >3,799999 > >-1,430511E-06 > >1,519918E-06 > >-1,937151E-07 > > > >this result i received from numbers that were entered directly in the > >Table.(see first mail) > > > >I don't know what hardware specifications you need, but its a laptop > >Acer Travelmate 620, Pentium III, CPU1000MHz > >535MHz and 248MB RAM, WindowsXP, Home edition > > > >Pedro Janssen > > > > > > > > > >----- Original Message ----- > >From: "Wortz, Charles" <CWortz at tea.state.tx.us> > >To: <accessd at databaseadvisors.com> > >Sent: Monday, April 07, 2003 8:03 PM > >Subject: RE: [AccessD] roundup - decimal places > > > > > > > Pedro, > > > > > > Are you datatyping your numbers as Single or Double? Even with Single > > > you get approximately seven (7) digits of precision. Thus your 5,1 will > > > be stored as some value between 5,000005 and 5,100005. The value you > > > claim is far outside of this range, leading me to conclude it is a > > > calculated value, not a value you entered directly. If it is a value > > > you entered directly, then please inform us of the hardware > > > specifications of your computer since it does not meet any of the > > > worldwide specifications for handling floating point numbers. > > > Charles Wortz > > > Software Development Division > > > Texas Education Agency > > > 1701 N. Congress Ave > > > Austin, TX 78701-1494 > > > 512-463-9493 > > > CWortz at tea.state.tx.us > > > -----Original Message----- > > > From: Charlotte Foust [mailto:cfoust at infostatsystems.com] > > > Sent: Monday 2003 Apr 07 12:42 > > > To: accessd at databaseadvisors.com > > > Subject: RE: [AccessD] roundup - decimal places > > > > > > > > > You're going to have to explain whether you want to truly round numbers > > > or just display them that way. The Decimal places setting addresses the > > > display, not the precision. > > > > > > Charlotte Foust > > > -----Original Message----- > > > From: Pedro Janssen [mailto:pedro at plex.nl] > > > Sent: Monday, April 07, 2003 9:25 AM > > > To: accessd at databaseadvisors.com > > > Subject: Re: [AccessD] roundup - decimal places > > > > > > > > > Hello Charles, > > > > > > when i type 5,1 i type 5,1 and not . > > > How does a computer changes 5,1 into 5,11415899 although i type 5,1. > > > > > > What is the use of decimal places:1, with field size: single, when the > > > pc makes a lott of decimal places from it. Then this property better > > > wasn't available when using numbers (not currency). > > > Is there a way to roundup the numbers to 1decimal place without using > > > currency. > > > > > > Pedro Janssen > > > ----- Original Message ----- > > > From: Wortz, Charles > > > To: accessd at databaseadvisors.com > > > Sent: Monday, April 07, 2003 5:42 PM > > > Subject: RE: [AccessD] roundup - decimal places > > > > > > > > > Pedro, > > > > > > Remember, you are working on a binary computer. Thus decimal numbers > > > must be approximated as the sum of powers of two. For integer numbers > > > these approximations are exact representations. For floating point > > > numbers, these approximations are just that - approximations. None of > > > your floating point numbers are stored with just one digit to the right > > > of the decimal point, they are only displayed to you as such. > > > > > > If you cannot learn to live with floating point numbers, then convert > > > them to the currency datatype. The currency datatype will meet many of > > > you computational needs. > > > > > > > > > Charles Wortz > > > -----Original Message----- > > > From: Pedro Janssen [mailto:pedro at plex.nl] > > > Sent: Monday 2003 Apr 07 10:30 > > > To: AccessD at databaseadvisors.com > > > Subject: [AccessD] roundup - decimal places > > > > > > > > > Hello Group, > > > > > > i have a tableA with 5 fields (field size: single, decimal places:1) > > > Not all fields have values. > > > I want the difference from al those field, so i added a field diff. > > > I made an update query with the following sql: > > > > > > UPDATE TableA SET TableA.[diff] = 100-Nz([field1],0)-Nz([[field2],0)- > > > etc. etc.; > > > > > > The result that i get in field diff gives many records with more then 1 > > > decimal places. > > > > > > For example: When i have a record which contains values like 5,1 and > > > 94,9 (all values are typed in this way and are not calculated) i get as > > > result 0,11176548 > > > or a record that contains values like 20,5 and 20,5 i get as result > > > 59,997854. > > > Some result do have only one decimal place. > > > > > > How is this possible? > > > > > > TIA > > > > > > Pedro Janssen > > _________________________________________________________________ > Tired of spam? Get advanced junk mail protection with MSN 8. > http://join.msn.com/?page=features/junkmail > > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >