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

In Access you can use numeric or currency.  If you use numeric the

default is AUTO for decimal places (which may be your problem).  If you

use currency, I believe the default is 2 decimal places.  Go into the

design mode of the table and make sure you force 2 decimal places

(change AUTO).  See if that works for you.  One other thing...you say it

gets rounded up.  While in the Access DB open the table and see the

value for the row with 0.76.  If it is 1, then the problem is on the

access side.  If 0.76, then show us your code.



-----Original Message-----

From: Craig Flannigan [mailto:ckf@k...]

Sent: Thursday, February 14, 2002 5:49 AM

To: ASP Databases

Subject: [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').