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

 

[Joseph Meehan]

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

Integer = Integer A member of the set of positive whole numbers (1, 2,
3, . . . ), negative whole numbers (-1, -2, -3, . . . ), and zero

Make the field type Currency and you should be ready to go.