Number Field Automatically Rounding Decimals

[Steve]

I am creating a new table, which will include a number field for the
length of a course. I want the number to the nearest hundreth (second
decimal point) but it sees that the default setting is to round to the
nearest whole number. How do I turn off the rounding get the table to
allow decimal points?

Here are the Field Properties:

Field Size - Integer
Format - Fixed (I have tried various formats that did not change the
rounding)
Decimal Places - 2
Input Mask -
Caption - CE Hours (50 Minute)
Default Value -
Validation Rule -
Validation Text -
Reqired - No
Indexed - No
Smart Tags -
Text Align - General

I have a similar field that is doing the same thing.

Thanks in advance!

Steve

 

[Duane Hookom]

Steve,
integers are integers which are whole numbers. Change the data type to
decimal or single or double so it can store what you want.

 

[Ken Snell]

Change from Integer to Double.

 

[Steve]

Thanks everyone, its really suprising how much 5th grade math I don't
remember. That fix made perfect sense and more importantly fixed my
problem completely! Thank you!