Sum in query returns scientific notation when amount is zero

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

Guest

When I sum an amount in a query, some of the amounts (not all) that net to
zero return a long number with an E in it.

Any ideas how I can avoid this or what is causing it?

Thanks in advance for your help!
 
When I sum an amount in a query, some of the amounts (not all) that net to
zero return a long number with an E in it.

Any ideas how I can avoid this or what is causing it?

Thanks in advance for your help!
Click to expand...

Make the textbox (or the datasheet column) in which this number is
displayed wider.

If there's not room for a large number, Access will (sometimes
counterproductively) switch to scientific notation; the idea is that
seeing 3.2E7 gives you *some* information, whereas seeint 32412451
truncated to 324124 is actively misleading and wrong.


John W. Vinson[MVP]
 
Back
Top