Numbers Rounding

  • Thread starter Thread starter Rob Sykes
  • Start date Start date
R

Rob Sykes

Hey, I have 2 Number field in a table, the autoformat is
set to currency. It keeps rounding to the nearest dollar
amount (all settings are default other than the currency
type). What's the deal? Thanks in advance.
 
You have to set the field type to currency. This is a different property
from setting the format.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
 
In table design view, select the Number field.
In the lower pane, change the Field Size property to:
Double
The "Integer" types can store only whole numbers.

Better still, why not choose Currency as the data type for the field? That
would be the best choice unless you need precision that goes beyond
hundredths of a cent.
 
Thanks, didn't know about the long int. only storing whole
numbers. Learn something new everyday :)
 
Back
Top