Calculate Date

  • Thread starter Thread starter Anthony W.
  • Start date Start date
A

Anthony W.

I working within a form and have three fields. One is the
start date, the other Expected length in weeks and the
other is the due end date. I have button that when
pressed calculates the due end date by adding the number
of weeks on to the start date.

What i want is another button that when pressed a box
appears which you can enter the amount of weeks you want
the person extending for into and then it calculates the
weeks by adding them on to the due end date.

Is this possible.

Any Help is much appreciated.

Thanks

Anthony
 
Anthony W. said:
I working within a form and have three fields. One is the
start date, the other Expected length in weeks and the
other is the due end date. I have button that when
pressed calculates the due end date by adding the number
of weeks on to the start date.

What i want is another button that when pressed a box
appears which you can enter the amount of weeks you want
the person extending for into and then it calculates the
weeks by adding them on to the due end date.
Click to expand...

Add the extended time field to the table. Make the default value zero
If you want a button then make the field invisible if it is zero and add a
button that set it visible when pushed.

The calculated field in your query will be EndDate:DateAdd("ww", EndDate +
AdditionalWeeks, StartDate)
 
Back
Top