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