[AccessD] roundup - decimal places

Pedro Janssen pedro at plex.nl
Mon Apr 7 12:25:28 CDT 2003


MessageHello 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 
  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: 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


------------------------------------------------------------------------------


  _______________________________________________
  AccessD mailing list
  AccessD at databaseadvisors.com
  http://databaseadvisors.com/mailman/listinfo/accessd
  Website: http://www.databaseadvisors.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030407/aaa9ea1a/attachment-0001.html>


More information about the AccessD mailing list