Currency Decimals

[Jorlypong]

How do I have the field show upto 5 decimal places in currency. When I enter
1.23054 it will return as 1.23050. In design view, I have the upperfield set
on currency and lowerfield format set on currency. With decimal place on 5,
6, 7, even 11 shows the same problem with more zeros at the end.

 

[karl dewey]

I have the upperfield set on currency and lowerfield format set on currency.
What are you looking at when you say 'upperfield' and 'lowerfield'?

Curency is only 4 decimal places. You are just add zeros.
Use Single or Double datatype with 5 decimal places.

 

[Jorlypong]

Karl,
Let me make sure I understand. Currency is unable to go up to 5 or 6 decimal
places so if I need 5 or 6 decimal places I will have to change the datatype
to number and the format to double?

 

[John W. Vinson]

How do I have the field show upto 5 decimal places in currency. When I enter
1.23054 it will return as 1.23050. In design view, I have the upperfield set
on currency and lowerfield format set on currency. With decimal place on 5,
6, 7, even 11 shows the same problem with more zeros at the end.

As Karl says, the Currency datatype actually stores four and only four
decimals. If you have A2002 or later, though, I'd suggest using a Number...
Decimal datatype (which can be set to store exactly five decimals) rather than
Double (which will allow up to some 14 decimals but may give roundoff error
problems).

 

[Jorlypong]

Thanks to both Karl and John

 

[fredg]

How do I have the field show upto 5 decimal places in currency. When I enter
1.23054 it will return as 1.23050. In design view, I have the upperfield set
on currency and lowerfield format set on currency. With decimal place on 5,
6, 7, even 11 shows the same problem with more zeros at the end.

If you mean Currency Datatype, then the following is from Access help
files on "Datatype":

"Currency values and numeric data used in mathematical calculations
involving data with one to four decimal places. Accurate to 15 digits
on the left side of the decimal separator and to 4 digits on the right
side."

Note that it is limited to up to 4 decimal places, so anything entered
after that will display as Zero.