RE: Number Field give wrong result.
- From: "KARL DEWEY" <KARLDEWEY@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 14 Jun 2005 09:41:07 -0700
You can not use a number field to give you years and months by entering
02.11. Standard numbers a decimal - otherwise known as base 10. Every
number is in powers of 10. Years have 12 months.
Access uses a numerical value to display dates and time. Each hole number
is a day and anything less than a day is a decimal faction. On display
Access converts the number to years, months, days, hours, minutes, and
seconds according to the selected presentation method.
You could use a date-time field to do what you want with a lot of work but
you did not say that the data was to be used in any calculation. So why not
just use a text field with an input mask.
"dbl" wrote:
> Hi I have a form with a field called "LicHeldFor" the data has to be entered
> in Years & Months. This data is used to work out the policy excess but
> gives me the wrong result i.e. 00Yrs 02Mths returns a value of 2. Also 02Yrs
> 00Mts returns the value of 2. (If a driver has held a licence for less that
> a full year then an additional excess is add to the policy)
>
> I need all data under 12 months to give a result of less than 1 i.e. 6
> months 0.06 11 months 0.11 as long as everything under 12 months returns
> less that 1 it will work fine.
>
> When I set up the field to show decimal places i.e. 00.01 it gives the
> following result 0.00 for some reason it only gives full numbers 1 2 3 etc.
>
> Is it possible to do this? if it is how do I go about it.
>
> Thanks for your help
>
> Bob
>
>
>
.
- References:
- Number Field give wrong result.
- From: dbl
- Number Field give wrong result.
- Prev by Date: Re: Query by last date?
- Next by Date: Re: Query by last date?
- Previous by thread: Number Field give wrong result.
- Next by thread: Re: Number Field give wrong result.
- Index(es):
Relevant Pages
|
