Error with sum of double type number

[Chlaris]

Hello,

I have the following table :

Table Name : tblStock

Field : Qty
Data Type : Number
Field Size : Double

The table has 4 records :

-8
-2.7
2.7
8

Run this sql statement :

SELECT Sum(tblStock.Qty) AS SumOfQty
FROM tblStock;

The query returns 8.88178419700125E-16
Actually it should be zero.

What's wrong with Double type format ?

Thanks.

Chlaris

 

[Tom Wickerath]

Hi Chlaris,

Here is a paper written by Luke Chung, President of FMS, Inc., on this topic:

When Microsoft Access Math Doesn't Add Up
http://www.fmsinc.com/tpapers/math/index.html


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[Chlaris]

Hi,

Thanks for the reference.

Chlaris

Hi Chlaris,

Here is a paper written by Luke Chung, President of FMS, Inc., on this
topic:

When Microsoft Access Math Doesn't Add Up
http://www.fmsinc.com/tpapers/math/index.html


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________