Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002

    Unanswered: Summation bug???

    I encountered a summation problem in Access, I'm not sure if this is a bug in Access 97 or maybe I'm doing something wrong. To make it short I was grouping by one of my tables and when I summed up the following number in that sequence I get "2.8421709430404E-14" as a result when it should be zero.


    I have the above in a number field (double).

    Any ideas why it's doing this, or is there something I'm doing wrong?

  2. #2
    Join Date
    Dec 2002
    Préverenges, Switzerland
    0.000000000000028421709430404 is pretty close to zero!

    double-precision is not infinite precision and depending on your calculations you are going to get some noise in the lower deimals. rounding will help if you dont need all these decimals.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts