A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

stop the rounding



 
 
Thread Tools Display Modes
  #1  
Old December 29th, 2009, 06:04 PM posted to microsoft.public.access.tablesdbdesign
MonaOH
external usenet poster
 
Posts: 1
Default stop the rounding

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??
  #2  
Old December 29th, 2009, 06:12 PM posted to microsoft.public.access.tablesdbdesign
fredg
external usenet poster
 
Posts: 4,386
Default stop the rounding

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??


Most likely the [Hours] field's datatype is Number with the Field Size
property set to Integer or Long Integer.
By definition an Integer is a whole number.... do decimal's allowed.
Change the Field Size property to Single, or Double.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
  #3  
Old December 29th, 2009, 06:26 PM posted to microsoft.public.access.tablesdbdesign
KARL DEWEY
external usenet poster
 
Posts: 10,767
Default stop the rounding

Check the number property to make sure you did not use the default datatype
of Integer. Use Single.

--
Build a little, test a little.


"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??

  #4  
Old December 29th, 2009, 07:40 PM posted to microsoft.public.access.tablesdbdesign
John W. Vinson
external usenet poster
 
Posts: 18,261
Default stop the rounding

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]
  #5  
Old December 30th, 2009, 05:39 PM posted to microsoft.public.access.tablesdbdesign
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default stop the rounding

You've been offered "Single", "Double", and "Decimal" data types to "keep"
your decimal places.

Let me offer one more ... "Currency". Yes, I know the name implies $$, but
it actually provides (up to) 4 decimal places' accuracy, so if you don't
need more than 4, it will do.

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"MonaOH" wrote in message
...
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??



 




Thread Tools
Display Modes

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

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:00 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.