Currency column rounding up or down

[SIMON GARE]

Hi,

I have a table with a list of values in currency, the only problem is that
when you enter a value the digits after the decimal point are rounded up or
down.

Example if you enter 2.40 it rounds down to 2.00 and if you enter 2.80 it
rounds up to 3.00

My setting are

DATA TYPE = NUMBER
FIELD SIZE = LONG INTEGER
FORMAT = CURRENCY
DECIMAL PLACES = AUTO

Thanks in advance

Simon

 

[Allen Browne]

Change the data type to Currency.

The integer types can store only whole numbers, so are not suitable if you
want fractions of a dollar (i.e. cents).