On Tue, 29 Dec 2009 09:04:01 -0800, MonaOH
wrote:

I'm using Access 2007. I have a very small business & am trying to use
access for payroll/hours. When I enter hours with decimal (ie" 7.5), it
automatically rounds to the next number. If I set the property for text, I
cant sum the column. I need to "turn off" the rounding feature by whatever
means & still be able to do mathematical calculations on that column. Can
anyone help??

I'm guessing that you set the datatype for this field to the default Number
datatype: Long Integer. An integer is, by definition, a whole number.

Open the table in design view and change the field's properties (in the lower
left corner of the screen) from Long Integer to Single, Double, or (probably
best) Decimal with appropriate scale and precision.
--

John W. Vinson [MVP]