|
 |
asp_databases thread: SV: Rounding Up...
Message #1 by =?us-ascii?Q?Hakan_Frennesson?= <hakan@c...> on Thu, 14 Feb 2002 12:00:14 +0100
|
|
Hi!
You have to change the field length to single instead of long integer which
is the default for the datatype. Check in design view of the table.
Hth,
Hakan
-----Ursprungligt meddelande-----
Fran: Craig Flannigan [mailto:ckf@k...]
Skickat: den 14 februari 2002 11:49
Till: ASP Databases
Amne: [asp_databases] Rounding Up...
Hi,
I am inserting values into a database field, but when checking the data,
Access is rounding up the values.
I entered for example, 0.76 and it's rounded it up to 1. How do I stop this
from happening?
The field is numeric and set to show up to 2 DP, but it doesn't stop the
rounding...
Any ideas what I am doing wrong?
Cheers
Craig.
_____________________________________________________________________
This message has been checked for all known viruses by Star Internet
delivered through the MessageLabs Virus Scanning Service on behalf of
Kingfield Heath Ltd. For further information visit
http://www.star.net.uk/stats.asp
$subst('Email.Unsub').
Message #2 by "Craig Flannigan" <ckf@k...> on Thu, 14 Feb 2002 11:09:11 -0000
|
|
Thanks - that's worked.
Cheers
Craig.
-----Original Message-----
From: Hakan Frennesson [mailto:hakan@c...]
Sent: 14 February 2002 11:00
To: ASP Databases
Subject: [asp_databases] SV: Rounding Up...
Hi!
You have to change the field length to single instead of long integer which
is the default for the datatype. Check in design view of the table.
Hth,
Hakan
-----Ursprungligt meddelande-----
Fran: Craig Flannigan [mailto:ckf@k...]
Skickat: den 14 februari 2002 11:49
Till: ASP Databases
Amne: [asp_databases] Rounding Up...
Hi,
I am inserting values into a database field, but when checking the data,
Access is rounding up the values.
I entered for example, 0.76 and it's rounded it up to 1. How do I stop this
from happening?
The field is numeric and set to show up to 2 DP, but it doesn't stop the
rounding...
Any ideas what I am doing wrong?
Cheers
Craig.
_____________________________________________________________________
This message has been checked for all known viruses by Star Internet
delivered through the MessageLabs Virus Scanning Service on behalf of
Kingfield Heath Ltd. For further information visit
http://www.star.net.uk/stats.asp
$subst('Email.Unsub').
$subst('Email.Unsub').
_____________________________________________________________________
This message has been checked for all known viruses by Star Internet
delivered through the MessageLabs Virus Scanning Service on behalf of
Kingfield Heath Ltd. For further information visit
http://www.star.net.uk/stats.asp
_____________________________________________________________________
This message has been checked for all known viruses by Star Internet
delivered through the MessageLabs Virus Scanning Service on behalf of Kingfield Heath Ltd. For further information visit
http://www.star.net.uk/stats.asp
|
|
|
View Cart
