Number Field Automatically Rounding Decimals

  • Thread starter Thread starter Steve
  • Start date Start date
S

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
 
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.
 
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!
 
Back
Top