numeric vs text

[dfbrown000@tds.net]

I have established a field for recording hours of work. I want to use only one decimal place (IE 2.5 hours) I created the field as a "long integer" and saved work. It will not let me enter the decimal place. When I enter "2.5" the filed converts it to "2". I can reset the field to "text", but then have to use "Val()" to convert. I know I have done this in the past (20 yrs ago) but can't seem to get it right. What's going on? I'm sure it is something simple, but I'm getting frustrated. Could use some help. Tks db

[pbaldy]

Try using Currency, Double or Single as the data type.

[dfbrown000@tds.net]

Thanks Paul. I'll try that. DIdn't think of currency. Will try double and single as well.

[pbaldy]

No problem. Double and Single are floating point numbers, so once in a while will give odd results.