Access is automatically rounding numbers to 0 decimal places. I get this problem the odd time and tried specifying the number of decimal places, etc. but it keeps happening. It is wrecking my head. I want to add an invoice value to the database from an asp/vb page. When I view it after input the value entered is rounded to 0 decimal places. EG:

1449.75 changes to 1450

Column values in access are set to the following:

Data type: Number
Field Size: Long Integar
Format:
Decimal Places: 2
Input Mask:
Caption:
Default Value: 0
Validation Rule:
Validation Text:
Required: No
Indexed: No


Any suggestions???

Regards,

Dave

_________________________
David Behan - www.site-manager.com/af.asp?a=11&l=1tds9p6x2

Try the Data Type as "Currency" instead of a Number

"Get the kettle on, time for a brew"

Well, an integer may be interpreted as a WHOLE INTEGER (in which .01 - .99 are truncated) Look for a FLOATING INTEGER possibility.

Aegis Kleais
New Media Web Developer
(DWMX : IIS5.1 : SQL2K : WXP : ASP[VB/JS])

I fixed it... stupid mistake that only occurs after staring at a computer for 12 hours plus. I am sure you know what I mean. Forgot to change the properties. For future reference... this is what I did:

Data type: Number
Field Size: Double
Format: Fixed
Decimal Places: 2
Input Mask:
Caption:
Default Value: 0
Validation Rule:
Validation Text:
Required: No
Indexed: No


Thanks

Dave

_________________________
David Behan - www.site-manager.com/af.asp?a=11&l=1tds9p6x2