Forum Discussion

robertallen2405's avatar
robertallen2405
Copper Contributor
Sep 20, 2024
Solved

Adding two numbers in a select query produces a slightly different number.

In a select query, the Field contains 'Total Net (inc Manual): [Manually Input Amount]+[Net Amount]'.  In one example, it should produce 20.6, but it produces 20.6000003814697. Both values do not c...
access
  • Karl_Donaubauer's avatar
    Karl_Donaubauer
    Sep 20, 2024

    Hi,

     

    Since you didn't reveal the data type of [Net Amount] in the underlying table, I can only guess that it is Single. If that's the case: This is the least useful and most inaccurate data type in the world. 😉 Change it to Double at the very least, or better yet, to Currency.

     

    Servus
    Karl
    ****************
    Access Forever News DevCon
    Access-Entwickler-Konferenz AEK - 19./20.10. Nürnberg

Karl_Donaubauer's avatar
Karl_Donaubauer
MVP
Sep 20, 2024

Hi,

 

Since you didn't reveal the data type of [Net Amount] in the underlying table, I can only guess that it is Single. If that's the case: This is the least useful and most inaccurate data type in the world. 😉 Change it to Double at the very least, or better yet, to Currency.

 

Servus
Karl
****************
Access Forever News DevCon
Access-Entwickler-Konferenz AEK - 19./20.10. Nürnberg

  • robertallen2405's avatar
    robertallen2405
    Copper Contributor
    Sep 20, 2024

    Karl_Donaubauer 

    Thank you (especially for your reply being so quick).

    You were right, it was Single; which I'd done to try and save storage space. But, it's no good if you can't perform even basic mathematical functions on them!

    Changed it to currency and it worked like a dream.

    Thanks again.

    • Ken_Sheridan's avatar
      Ken_Sheridan
      Brass Contributor
      Sep 20, 2024

      You might find the following link of interest:

       

      https://www.sfmagazine.com/articles/2017/march/access-numbers/

       

Resources