Let me preface this by saying thank you in advance, I got stuck with a project at work and know next to nothing about Access programming and am trying to fumble through it.
My Tables are:
Badge
Date_Of_Incident
Description
Code
Comment
Points
Drop Date
Here is what I need.
The Drop Date field should be 90 Days from the date of Incident (I've got that working). UNLESS there is another incident in the last 90 days, then it has to be 1 year from the date of the latest incident.
I am lost with respect to the one year date. Any advice would help.
My Tables are:
Badge
Date_Of_Incident
Description
Code
Comment
Points
Drop Date
Here is what I need.
The Drop Date field should be 90 Days from the date of Incident (I've got that working). UNLESS there is another incident in the last 90 days, then it has to be 1 year from the date of the latest incident.
I am lost with respect to the one year date. Any advice would help.