Number format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have some tables where numbers like 320.3 are entered, but when I run a
query that turns into 320.2999877.... Why is that happening and how can I fix
it? thanks for the help.
 
Just a guess, but is the data type of that field set to Double, or to
Single? There's an issue with binary representation of decimal numbers...

What happens if you set the data type to Currency, with one decimal place?

Good luck

Jeff Boyce
<Access MVP>
 
The field is data type Number, field size Single, decimal places 2.
If I set it to currency will that cause problems when I use it in
calculations.
Is there some other way to format the numbers to only display up to 2
decimal points. thanks
 
If you need a number that is accurate to more than 4 decimal places, use
Single (or Double). If you will never need accuracy greater than 4 places,
use currency.

Jeff Boyce
<Access MVP>
 
Back
Top