In a table created to log labor hours the data either rounds up (7.5 rounds
to 8) or rounds down (4.5 rounds down to 4). I have the decimals set to 2
places. How can I fix this

Deb

Display (i.e., formatting) is not the same as data type (e.g., Integer).

Is there a chance the underlying field's data type is Integer? Integers are
whole numbers, no matter how you wish to display it...

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Deb" <(E-Mail Removed)> wrote in message
news:111FE3A8-122B-4785-B287-(E-Mail Removed)...
> In a table created to log labor hours the data either rounds up (7.5
> rounds
> to 8) or rounds down (4.5 rounds down to 4). I have the decimals set to 2
> places. How can I fix this

In your form set the Format as #.## for the text box.

"Deb" wrote:

> In a table created to log labor hours the data either rounds up (7.5 rounds
> to 8) or rounds down (4.5 rounds down to 4). I have the decimals set to 2
> places. How can I fix this

On Fri, 8 Sep 2006 09:26:02 -0700, KARL DEWEY
<(E-Mail Removed)> wrote:

>In your form set the Format as #.## for the text box.
>
>"Deb" wrote:
>
>> In a table created to log labor hours the data either rounds up (7.5 rounds
>> to 8) or rounds down (4.5 rounds down to 4). I have the decimals set to 2
>> places. How can I fix this

Also check the datatype of the field. If it's the default Long Integer
type of Number, then it HAS no decimal places - integers are whole
numbers by definition. Change it to Float or Double if that's the
case.

John W. Vinson[MVP]

Hi Deb,
just choose in design mode, the Field zise of your table field to Reel or
Double; and change Format to General Number and set your Decimal to 2.

"Deb" <(E-Mail Removed)> a écrit dans le message de news:
111FE3A8-122B-4785-B287-(E-Mail Removed)...
> In a table created to log labor hours the data either rounds up (7.5
> rounds
> to 8) or rounds down (4.5 rounds down to 4). I have the decimals set to 2
> places. How can I fix this