decimal place format

[Terry]

I am currently using the INVENTORY CONTROL database that
is included in MS Access 2000. I have set the number of
decimal places in the UNIT PRICE field to 5; however,
everytime I enter a number such as .00385, the number
displayed is .00380. I have checked all tables to be sure
that the decimal place is set to 5 where UNIT PRICE is
applicable. Am I missing something somewhere?

Thanks.

 

[Tim Ferguson]

I have set the number of
decimal places in the UNIT PRICE field to 5; however,
everytime I enter a number such as .00385, the number
displayed is .00380.

Check the data type: if it's a Currency type then it will only hold four dp
by definition. You might be better off with a Double or Single Float, or
else with scaling the values.

HTH


Tim F