Tech Support Guy banner

Access, notifications based on 2 different due dates

584 Views 1 Reply 2 Participants Last post by  Chawbacon
Hi, I am very new to Access and I am trying to design notifications based on 2 different due dates (Yearly & Semi-yearly). The document is the same for each employee, but some employees are due every 6 months and some every 12. I have found a way in a query to do either the 6 month notice, or the 12 month, but not both. Is this even possible? Or do I somehow need to set up my table differently?
Status
Not open for further replies.
1 - 2 of 2 Posts
Hello There 777Psalm91,

Since it seems like you have a decent start on this one, a detailed response is probably not needed.

Try a nested IIF statement to evaluate the month value of the EmployeeStartDate and the value of the ServiceInterval, then define your desired output accordingly.

Good Luck
1 - 2 of 2 Posts
Status
Not open for further replies.
Top