G
Guest
I have a DB that records staff appraisals. When an appraisal is added, I need
to calculate a review date 6 months after the actual appraisal date.
I have a text field in a form with the following:
=IIf([Actual Date] Is Not Null,DateSerial(Year([Actual Date]),Month([Actual
Date])+6,Day([Actual Date])))
Which works in the form, but I have just noticed it does not write the
review date to the table, so I can't use queries to find out when reviews are
due.
So, I need for the table to be able to create and store this value for me
after and actual date has been added into the record.
Any help greatly appreciated!
to calculate a review date 6 months after the actual appraisal date.
I have a text field in a form with the following:
=IIf([Actual Date] Is Not Null,DateSerial(Year([Actual Date]),Month([Actual
Date])+6,Day([Actual Date])))
Which works in the form, but I have just noticed it does not write the
review date to the table, so I can't use queries to find out when reviews are
due.
So, I need for the table to be able to create and store this value for me
after and actual date has been added into the record.
Any help greatly appreciated!