I am currently working on an Employee Database dealing with various vaccinations, and have run into a bit of a snag. Iím adding in an optional vaccination that has both an annual and a six-month titre.
Iím trying to add in an expression that checks to see if the six-month titre box has been checked off, but I donít have much experience in VB, and havenít used what I DO know for years.
Iím basically looking at something along the lines of:
IF [VaccinationRequired] = Yes and [6monthtitre] = Yes, then [TitreReview] = [LastTitre]+6 months Or IF [VaccinationRequired] = Yes and [6monthtitre] = NO, then [TitreReview] = [LastTitre]+12 months
But I have no idea how to get this working properly. Any help would be appreciated.