[AccessD] no automatic round up/off

Hi Pedro

Data type Integer and Long and Byte have per definition no decimals.
If four decimals is fine, use Currency for the field. Else Single or Double. Avoid Decimal as this is known to be buggy.

/gustav

>>> pedro at plex.nl 11-07-2008 10:06 >>>
Dear List,

i have a form with a recordsource to a query, which is related to a table, in a access 2003 database (and filerange of access 2000).
Teh table has numeric fields with Integer field length, 1 decimal place and a notation that is set to: #,#
Also the fields in the query and form are set to 1 decimal place and notation #,#

each time a place a value in the form like 5,4 it is round off to 5,0. But i want the original value 5,4 as data. No rouding up or off.

How can i do this?

Thanks

Pedro