SUM IN QUERY PRODUCES 2.273737E-13

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

SUM EXPRESSION IN QUERY PRODUCES THIS EXTREMELY SMALL FRACTION WHEN IT SHOULD
= ZERO. ANYONE SEEN THIS BEFORE???
 
Probably you are seeing the result of using a floating point number.
Floating point number (single and double) that have decimal portions cannot
be accurately represented (just as one third cannot be accurately
represented as a decimal fraction) and there will often be a minor
difference such as this when preforming math operations.

You can use currency (which is a scaled number with four decimal places) or
you can test for a very small difference and convert that to zero.

IIF(Abs(Sum(x)) <.0000000001,0,Sum(x))



--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Running Sum in Cross Tab Query 0
Sum Expression gives 1.45519152283669E-11 instead of 0 (zero) 6
SUM in a UNION query 2
Help Needed: Create Sum in Report Footer based on aggregate expression 1
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Incorrect sum in MS Access query 1
crosstab with conditional SUM() 1
Divide by Zero error 3

Back
Top