Access- Decimal part missing

[elizcelt]

Hi everyone!
I hope you could help me!
In my access database, I have numeric fields with decimals, and when I try to pass a value from ASP to any of these fields the decimal part is rounded, why?
Here is the example code:
<%
wCuota = Trim(Request.Form(&quot;Cuota&quot)
Set oConn = Server.CreateObject (&quot;ADODB.Connection&quot
oConn.Open &quot;Provider=Microsoft.Jet.OLEDB.4.0; Data Source=&quot;& Server.MapPath(&quot;../datos/datos.mdb&quot

Set RS = Server.CreateObject (&quot;ADODB.RecordSet&quot
sql = &quot;SELECT * from afiliado where afiliado = 178&quot;

RS.Open sql, oConn , 2, 3

RS(&quot;cuota_vista&quot = wCuota
RS.Update

Response.Write &quot;Value of my Variable:&quot; & wCuota
Response.Write &quot;Value of my Field: &quot; & RS(&quot;cuota_vista&quot
%>

The result is something like this:

Value of my Variable:15.75
Value of my Field: 16

The data type in the access field is numeric.

I don't know why, and I've searching about it, but I can't find an answer yet.

Thanks in advance.
Elizabeth

 

[onpnt]

The field in access may be number but the datatype (format etc) may be set to soemthing causing the rounding. double check the settings.

if it is
fieldsize: long integer, integer, single, double
decimals: auto, 0,1,2,3,4, etc...

____________________________________________________
_{The most important part of your thread is the subject line.
Make it clear and about the topic so we can find it later for reference. Please!! faq333-3811}

http://www.onpntwebdesigns.com

 

[onpnt]

should be
Field Size: double
Decimal Places: 2


____________________________________________________
_{The most important part of your thread is the subject line.
Make it clear and about the topic so we can find it later for reference. Please!! faq333-3811}

http://www.onpntwebdesigns.com

 

[elizcelt]

Thank you so much, as matter of fact, I didn't realize, it was setting as Integer, I'm such a newbie on this, but I'm learning, thank you.

 

[DJS2]

Numeric datatypes on Access tend to default to integer. You will need to change it to something like double and set the decimal places.