Prev: One database or more
Next: Number field...how does one show decimal places ?
From: Mohammad Yar Mohammad on 5 Jul 2008 09:34
I have designed a table. The numeric fields are defined as:
fILED TYPE :NUMBER;
FIELD SIZE : LONG INTEGER;
DECIMAL PLACES:2

The problem, I am facing is,"The data entered in this field is rounded
automatically.
For example a value '12.10' is rounded as '12' and a value 12.51' is rounded
as '13'".
How can I overcome this problem.
From: Douglas J. Steele on 5 Jul 2008 10:23
Long Integers cannot store decimal places: they're integers.

Change the Field Size to something that can accomodate decimals, like Single
or Double.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Mohammad Yar" <Mohammad Yar(a)discussions.microsoft.com> wrote in message
news:CBFB5D2D-DD97-4A59-8D77-D31B5DA9AD53(a)microsoft.com...
>I have designed a table. The numeric fields are defined as:
> fILED TYPE :NUMBER;
> FIELD SIZE : LONG INTEGER;
> DECIMAL PLACES:2
>
> The problem, I am facing is,"The data entered in this field is rounded
> automatically.
> For example a value '12.10' is rounded as '12' and a value 12.51' is
> rounded
> as '13'".
> How can I overcome this problem.


 | 
Pages: 1
Prev: One database or more
Next: Number field...how does one show decimal places ?