Fomula in a Text Box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have form for employees, on this form there is an is a field in which the date of the employees induction is stored

I created a text box and added the formula below to highlight if the employee needed a review induction. ie if the employee had been there for more than 1 year, then a review needs to be done. I want this to display on the form because it will only be looked at if a casual employee is going permanent BUT if I put the "greater than" sign one way they all come up the same and if I reverse it they all come up the other remark. Waht have I done wrong...

=iif([Induction Date]>(now()-365),"A review induction must be completed","A review induction is not necessary"

All help much appreciated

Thank
 
PJ,

Simply:
="A review induction " & IIf(DateAdd("yyyy", 1, [Induction Date]) > Date(),
"must be completed.", "is not necessary.")

However, there appears to be no way to include employees who were inducted
more than a year ago, but have not had their induction review yet. I suggest
adding a field to indicate the date an induction review was conducted. Then
you could include that in your formula.

="A review induction " & IIf(DateAdd("yyyy", 1, [Induction Date]) >= Date(),
"must be completed.", IIf([Review Date] Is Null, "is overdue.", "is not
necessary."))

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html


PJ said:
I have form for employees, on this form there is an is a field in which
Click to expand...
the date of the employees induction is stored.
I created a text box and added the formula below to highlight if the
Click to expand...
employee needed a review induction. ie if the employee had been there for
more than 1 year, then a review needs to be done. I want this to display on
the form because it will only be looked at if a casual employee is going
permanent BUT if I put the "greater than" sign one way they all come up the
same and if I reverse it they all come up the other remark. Waht have I done
wrong....
=iif([Induction Date]>(now()-365),"A review induction must be
Click to expand...
completed","A review induction is not necessary")
 
Back
Top