Re: Update numbers in database

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

Hi john,..

it is working.
But i still use the 5,3 input format, because some personell have experience
from different types of vessels, and im looking for only one type. And they
know
what their experience is. or else i had to put in many dates for making this.

i used the datediff funcsion to make out the days and divided on days in a
month and/or months a year to get the correct format. The format is also a
requirement
on the report. the numbers will only be updated on the reports.

thanx alot again for your input,

brgrds
inge

"John W. Vinson" wrote:

On Sun, 30 Nov 2008 03:41:00 -0800, inge <inge@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:

how can i update the inputs looking like 5,3 or 7,3 using the input numbers
and date? example,.. when a year have ellaps after the first time
registration the 5,3 number should show 6,3 and the 7,3 number should show
8,3. or after 6 months 5,3 should be 5,8 etc.

Inge, did you ever get this working?
--

John W. Vinson [MVP]

.

Relevant Pages

  • Re: Query Help Needed
    ... John W. Vinson wrote: ... The format is irrelevant - it does not affect what's stored, ... for that month using a self join query like: ...
    (microsoft.public.access.queries)
  • Re: copy records next in order
    ... "John W. Vinson" wrote: ... Number field with the prefix introduced by the format setting? ... for there initials and it will add those records to the table. ...
    (microsoft.public.access.queries)
  • Re: calculation problem
    ... "John W. Vinson" wrote: ... Do you have any of these fields defined with a Percent format? ... You may want to try deleteing the control from the form; compact the database; ...
    (microsoft.public.access.modulesdaovba)
  • Re: Yes/No field appears as -1/0
    ... "John W. Vinson" wrote: ... I have a Yes/No field but in all queries and reports it appears with the ... set the Format property of the textbox bound to the yes/no field ...
    (microsoft.public.access.gettingstarted)
  • Re: calculation problem
    ... "John W. Vinson" wrote: ... Do you have any of these fields defined with a Percent format? ... Doublecheck the Format property of the *textbox* on the form. ...
    (microsoft.public.access.modulesdaovba)