access thread: Inserting Numbers into Access database
Message #1 by "Sheri Martinez" <smartinez@w...> on Wed, 14 Feb 2001 02:41:46
|
|
I am trying to insert a number into an Access data base and it is rounding
my number (example: 16.50 is 16.00 and 16.95 is 17.00). How can I get the
EXACT number to be inserted into the Access data base?
Message #2 by "Z" <zzz8611@y...> on Wed, 14 Feb 2001 07:14:33
|
|
> I am trying to insert a number into an Access data base and it is
rounding
> my number (example: 16.50 is 16.00 and 16.95 is 17.00). How can I get
the
> EXACT number to be inserted into the Access data base?
>
Message #3 by "Pardee, Roy E" <roy.e.pardee@l...> on Wed, 14 Feb 2001 07:24:25 -0800
|
|
Sounds like either a display format or a field type problem--what sort of a
number field are you using? What have you set for the Decimal Places and
Format properties?
-----Original Message-----
From: Sheri Martinez [mailto:smartinez@w...]
Sent: Wednesday, February 14, 2001 6:34 AM
To: Access
Subject: [access] Inserting Numbers into Access database
I am trying to insert a number into an Access data base and it is rounding
my number (example: 16.50 is 16.00 and 16.95 is 17.00). How can I get the
EXACT number to be inserted into the Access data base?
Message #4 by "Z" <zzz8611@y...> on Wed, 14 Feb 2001 16:28:17
|
|
> I am trying to insert a number into an Access data base and it is
rounding
> my number (example: 16.50 is 16.00 and 16.95 is 17.00). How can I get
the
> EXACT number to be inserted into the Access data base?
>
How about changing your data type to double and set your decimal places?
Message #5 by John Fejsa <John.Fejsa@h...> on Thu, 15 Feb 2001 08:17:32 +1100
|
|
Can you double-check to make sure the receiving field is set up as double
and not as integer.
>>> smartinez@w... 15/02/2001 1:33:40 >>>
I am trying to insert a number into an Access data base and it is
rounding
my number (example: 16.50 is 16.00 and 16.95 is 17.00). How can I get
the
EXACT number to be inserted into the Access data base?
.au
|
View Cart
