Forum Discussion

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

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

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
Brass Contributor
Sep 20, 2024
You might find the following link of interest:

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