Re: Stop numbers from Rounding

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: fredg <fgutkind@xxxxxxxxxxxxxxx>
Date: Thu, 12 Jan 2006 12:30:13 -0800

On Thu, 12 Jan 2006 12:08:03 -0800, NealJH wrote:

> How do you stop numbers from rounding to whole numbers in Access 2003.
>
> Thanks
>
> NealJH

What is the Field Size property of the field?
If it is Integer or Long Integer, by definition Integers are whole
numbers and cannot have a decimal value.
Change the field size to Single or Double.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
.

Prev by Date: Re: format field in an Access to show that an entry must be 3 digits
Next by Date: Re: Query Help
Previous by thread: Re: format field in an Access to show that an entry must be 3 digits
Next by thread: Re: Stop numbers from Rounding
Index(es):
- Date
- Thread

Relevant Pages

Re: Problem comparing double values
... > better than the epsilon test even if it will probably be ever so ... > of its own due to its use of Banker's Rounding. ... VB.Net: "Fool me once..." ... Prev by Date: ...
(microsoft.public.vb.general.discussion)
I am trying to round up to the nearest 25 cents
... I am trying to round a money value to the nearsest 25 cents and it keeps ... rounding to the nearest dollar HELP ... Prev by Date: ...
(microsoft.public.excel.newusers)
Another rounding issue
... Here's another rounding issue I just discovered: ... Without preformatting cell D2 it defaults to GENERAL and unexpectedly ... Biff ... Prev by Date: ...
(microsoft.public.excel.worksheet.functions)
Re: Voyager 1 8.7 billion miles from Sun
... >>> its called rounding off. ... I chose 100 AU's. ... is no dim bulb. ... Prev by Date: ...
(sci.astro.amateur)
Re: How can formulas be used to create another formula?
... I have found out what it is, very simple - rounding! ... "JE McGimpsey" wrote: ... >> To be honest it's that simple I can't understand what i'm doing wrong! ... Prev by Date: ...
(microsoft.public.excel.misc)