I use the SELECT statement of a field minus another field (example 9.9899999998132 - 9.9900000000818) I have the query result as -2.68602917685715E-11.
why it isn't showing something like this
-0.00000000026859936497
I use the SELECT statement of a field minus another field (example 9.9899999998132 - 9.9900000000818) I have the query result as -2.68602917685715E-11.
why it isn't showing something like this
-0.00000000026859936497
It's showing the number in scientific notation. Access has issues with very large and very small numbers, or did until Access2016. Review https://support.office.com/en-us/art...f-b77bae076f70
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Thank you for the information. That was helpful.