automatic round function

[ngoc tung]

I am using the ACCESS 2003 for my management, but i have problem, as follows:
I make the form from query by using wizard, but when I type the number into
this form (ex: type 2.40) it is always chanced to 2.00 automatically or I
type 2.50, it is always altered to 3.00. Although, I have already to make the
format on properties like: format: Standard, decimal: 2.
Please tell me how can i remove this problem.
Thanhk and best regards.
TUNG

 

[Douglas J. Steele]

It sounds as though you forgot to change the data type of the numeric field
from its default Long Integer to a type that can hold decimal values (like
Single or Double)