Currency column rounding up or down

  • Thread starter Thread starter SIMON GARE
  • Start date Start date
S

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
 
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).
 
SIMON said:
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
Click to expand...

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