Subject Linked Table and double precision
Author Check_Mail

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