F
f
Hi,
I have a query which gathers the following data:
calculates the number of days someone has held a
position, based on the start date and today's date. The
fields are employee_id, nbr_retention_days, startdate,
enddate, lastcontactdate (last date the employee was
contacted at their job).
The output is to a form. My question is, that now I need
the form to do the following upon opening:
List those who have been in a position at 7 days, 14
days, 30 days, 60 days and 90 days -- IF they have NOT
been contacted at least one day before they reach each of
these milestones (7 days, 14 days, 30 days, 60 days, 90
days.
Any ideas appreciated.
-f
I have a query which gathers the following data:
calculates the number of days someone has held a
position, based on the start date and today's date. The
fields are employee_id, nbr_retention_days, startdate,
enddate, lastcontactdate (last date the employee was
contacted at their job).
The output is to a form. My question is, that now I need
the form to do the following upon opening:
List those who have been in a position at 7 days, 14
days, 30 days, 60 days and 90 days -- IF they have NOT
been contacted at least one day before they reach each of
these milestones (7 days, 14 days, 30 days, 60 days, 90
days.
Any ideas appreciated.
-f