> Hi Everyone,
> My problem is very simple and yet I could not solve this problem.
[quoted text clipped - 10 lines]
>
> Can somebody please tell me what is wrong?
Look at the underlying table in design view. Specifically the Data Type of
the Wqty field. My guess is that it is currently set to "Number" with a
size of either Integer or Long Integer neither of which support fractional
values.
You would either need to change the size to Single or Double, or change the
Type to Currency or Decimal. I prefer Currency because the Access
implementation of the Decimal type has a few issues. Even if your data is
not "currency" you can still use that type and use formatting to eliminate
the dollar sign from view.
Also note that Single and Double are "imprecise" types meaning that the data
as stored can introduce rounding issues (what you enter or see is not
necessarily the actual value stored). Currency and Decimal do not have that
issue.

Signature
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com