decimal place format

  • Thread starter Thread starter Terry
  • Start date Start date
T

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.
 
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.
Click to expand...

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
 
Back
Top