Sum in query returns scientific notation when amount is zero

[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!

 

[John Vinson]

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!

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]

 

[Guest]

Sounds like a scientific notation. Check your format property of the display.