Numbers Rounding

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

 

[Adrian Jansen]

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

 

[Allen Browne]

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.

 

[Rob Sykes]

Thanks, didn't know about the long int. only storing whole
numbers. Learn something new everyday