How do I keep number field from automatically rounding up fraction

[Hsectech]

I'm trying to format a number field to except partial hours for a time sheet.
How do I format that to stop rounding up to the next whole hour?

Thanks!

 

[fredg]

I'm trying to format a number field to except partial hours for a time sheet.
How do I format that to stop rounding up to the next whole hour?

Thanks!

Most likely the Number field's Field Size is Integer.
By definition, an Integer is a whole number, and cannot have a decimal
value.

Change the Field Size to Single or Double.

 

[Jeff Boyce]

In addition to FredG's suggestion, if you will only ever need 4 decimal
places or less, consider using the Currency data type. It will have fewer
issues with rounding errors.

Regards

Jeff Boyce
Microsoft Office/Access MVP