accurate

[Guest]

In Excel I can calculate 'precision as displayed'
In Acces: i have:
618 - 58.71 - 6.5 - 40.17
Seeng: 617 - 59 - 7 - 40
The result is 513
But if I have
618 - 59 - 7 - 40 i must have 512 ! How shall I do?
Thank you

 

[Joseph Meehan]

In Excel I can calculate 'precision as displayed'
In Acces: i have:
618 - 58.71 - 6.5 - 40.17
Seeng: 617 - 59 - 7 - 40
The result is 513
But if I have
618 - 59 - 7 - 40 i must have 512 ! How shall I do?
Thank you

These problems usually are the result of the number type. Integers do
not have decimals other types do. You need to consider both how a number is
displayed and how it is stored.

I know this is a little vague, but I can't figure out exactly what is
happening from your description. I looks like you may have a integer type
filed and you are trying to use it for decimals.