Subject | Linked Table and double precision |
---|---|
Author | Check_Mail |
Post date | 2019-10-30T10:58:03Z |
Hello,
I use Microsoft Access as frontend, firebird 3 superserver as backand. Now, there a many linked tables in access over firebird odbc, some of the colums are in double precision format.
Now, I don’t know why, in a Report I calculate the VAT, in my case:
279.578,50 * 0,19
If I calculate it wit a calculator, I get 53.119,915
The frontend calculates me 53.119,143 and in result, the final sum is wrong. 915 should 92, but 914 will be 91.
Thanks for your Help.
Regards
Olaf