Data intergity issue

[Mobiusrune]

In my database, I am tracking Lactate values. The data is reported from the lab as #.##

I set up with table and form orginially as a general number with 2 decimal places. I noticed that the field in the Table and Form was being rounded to the nearest whole number.

I then changes the from a general number to a fixed (and then later to Standard). But still had the same issues with the automatic rounding to the nearest whole number.

None of my other fields are doing this. I am at my wit's end with this. Any suggestions?:banghead:

 

[RuralGuy]

In order to have decimal places, the field type needs to be single, double or currency (good to 4 places). Your rounding is caused by the field being either an integer or long integer.

 

[Mobiusrune]

Thank you for the help. I knew I was missing something simple.