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

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"SIMON GARE" <(E-Mail Removed)> wrote in message
news:OJREGJ%(E-Mail Removed)...
>
> 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

SIMON GARE wrote:
> 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.


> FORMAT = CURRENCY
> DECIMAL PLACES = AUTO
>
> Thanks in advance
>
> Simon

--
Joseph Meehan

Dia duit