PC Review


Reply
Thread Tools Rate Thread

data entered in access table displays as a rounded up or rounded d

 
 
=?Utf-8?B?RGVi?=
Guest
Posts: n/a
 
      8th Sep 2006
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
 
Reply With Quote
 
 
 
 
Jeff Boyce
Guest
Posts: n/a
 
      8th Sep 2006
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



 
Reply With Quote
 
=?Utf-8?B?S0FSTCBERVdFWQ==?=
Guest
Posts: n/a
 
      8th Sep 2006
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

 
Reply With Quote
 
John Vinson
Guest
Posts: n/a
 
      8th Sep 2006
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]
 
Reply With Quote
 
David PONDA
Guest
Posts: n/a
 
      12th Sep 2006
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



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
add rounded numbers using the rounded value Ruth Microsoft Excel Misc 2 8th Feb 2010 07:59 PM
rounded table corners help Paul C Microsoft Frontpage 2 7th Feb 2007 12:29 PM
rounded value in Pivot Table =?Utf-8?B?cmVhbHNwaWRv?= Microsoft Access 0 9th May 2006 10:14 AM
How to get underlying rounded numbers in Access data cells? =?Utf-8?B?TGVubiBQcmltbQ==?= Microsoft Access 1 15th Oct 2005 07:16 PM
How to get underlying rounded numbers in Access data cells? =?Utf-8?B?TGVubiBQcmltbQ==?= Microsoft Access 1 15th Oct 2005 06:53 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:22 AM.