Insert and Store Decimal values in a Access Table

[Farida]

Hi,



I have a form that has INSERT query on a button as below.
The immediage window displays below result for my query which is ok.

INSERT INTO PROJECTS_DATA([MOC NUMBER], [LOCATION NAME], [PROJECT_ENG], [LEAD_ENG], [SHUTDOWN_YEAR], [FRAMING_SESSION], [PLANNED_DATE], [PR_NO], [CONTRACT_NO], [ACTUAL], [PLANNED], [VARIANCE], [PROGRESS], [MOC_CLOSURE], [STATUS], [PLAN], [CONCERN]) VALUES ('CR14-00001','', '', '', '', 0, '', '', '', 45.8, 5.69, 40.11, '', 0, '', '','')

I want to emphasize passing of the percentage values to the table (highlighted in red). In the table the data is stored as below.

Please advise, why my decimal value is getting truncated? Below is the field properties.



Ideally, these are actually percentage values and it will be great is you can also advise me how i can pass & store these as percentage values.

[JoeM]

Apparently, using the Decimal type can be problematic (see: http://www.fmsinc.com/microsoftacces...type/index.htm).
Try using Single or Double instead.

I was able to re-create the exact same issue you reported, and when I changed it to Single/Double, it worked properly.

[NTC]

change format to Fixed, and scale to 2

[Farida]

Worked like a charm. Thanks JoeM.

In the database i chnaged the field size to Single
And in the form, i changed the textox format to Fixed.

Thanks.