Re: Access-0.25 shows as zero in table-I want 0.25
- From: John Vinson <jvinson@xxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Sat, 07 Oct 2006 18:10:47 -0600
On Sat, 7 Oct 2006 08:55:02 -0700, B A Sullivan <B A
Sullivan@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
How do I get my number fields to display values that are less than 1 as the
actual value; e.g., 0.25?
By default, a Number field is defined as a Long Integer. Integers are,
by definition, whole numbers, and cannot accept fractional values such
as 0.25 or 1.25.
Either change the properties of the field - in the lower left corner
of the table design screen when you select the field - from Long
Integer to Float or Double; or change the datatype of the field itself
from Number to Currency. Float and Double are accurate to about 7 or
14 decimal places' accuracy, but both have problems with "roundoff
error"; Currency handles exactly four, no more and no fewer, decimal
places with no roundoff problems.
Depending on your version of Access, you may also have a Decimal size
property. Be aware that this has some bugs: see
http://support.microsoft.com/kb/837148/en-us
John W. Vinson[MVP]
.
- Follow-Ups:
- Re: Access-0.25 shows as zero in table-I want 0.25
- From: Jamie Collins
- Re: Access-0.25 shows as zero in table-I want 0.25
- Prev by Date: Re: Access-0.25 shows as zero in table-I want 0.25
- Next by Date: Re: Number feild for weight
- Previous by thread: Re: Access-0.25 shows as zero in table-I want 0.25
- Next by thread: Re: Access-0.25 shows as zero in table-I want 0.25
- Index(es):
Relevant Pages
|
