Decimal places

  • Thread starter Thread starter DamianF
  • Start date Start date
D

DamianF

Hi,

I'm have atable with various columns containing
information in euros. For some reason it will not let me
use cents because it always rounds them up or down to the
nearest euro. I have gone into table design and changed
the decimal places from "Automatic" to "2" but this
achieves nothing either. Can someone help me out in this?
 
Damian,

In your table design, check the data type of the amount field. Any chance
it's Integer or Long Integer (quite likely, I think this is the Access
default for numeric fields, if you don't change it)? If yes, change to
Double. Integers can't handle decimals!

HTH,
Nikos
 
Hi,

I'm have atable with various columns containing
information in euros. For some reason it will not let me
use cents because it always rounds them up or down to the
nearest euro. I have gone into table design and changed
the decimal places from "Automatic" to "2" but this
achieves nothing either. Can someone help me out in this?
Click to expand...

If you have this in the default Number datatype field - Long Integer -
then you won't be able to store decimals. I'd suggest changing the
datatype to Currency (it's another datatype like Date/Time or Text);
this gives you four decimals and (unlike Float or Double) no roundoff
error.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top