Decimal places

[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?

 

[Nikos Yannacopoulos]

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

 

[John Vinson]

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?

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