B
BetaMike
We record each employee’s DateOfBirth in tblEmployees and want to create an
alert when they reach retirement age (65yrs in the UK). Employees can choose
to work beyond their 65th birthday if they wish so we need some kind of
prompt to remind us to contact them in advance.
I have entered the following expressions in the relevant qryEmployees
DateOfRetirement: DateAdd("m",780,[DOB])
RequestMedical: [DateOfRetirement]-90
This shows the date of retirement and displays a date 90 days prior to this.
Would it be possible to setup some kind of alert when a user logs in? Any
suggestions would be appreciated
Thanks.
alert when they reach retirement age (65yrs in the UK). Employees can choose
to work beyond their 65th birthday if they wish so we need some kind of
prompt to remind us to contact them in advance.
I have entered the following expressions in the relevant qryEmployees
DateOfRetirement: DateAdd("m",780,[DOB])
RequestMedical: [DateOfRetirement]-90
This shows the date of retirement and displays a date 90 days prior to this.
Would it be possible to setup some kind of alert when a user logs in? Any
suggestions would be appreciated
Thanks.