How do I keep number field from automatically rounding up fraction

[Guest]

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

 

[Jamie Collins]

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.

In addition to Jeff Boyce's suggestion, if you ever need a rounding
algorithm other banker's rounding, more than 4 decimal places,
division to result in exact values, no implication of money data, etc
consider using the DECIMAL data type. Like CURRENCY, it is an exact
numeric type.

Jamie.

--