I'm sure this is simple, but I haven't programmed anything in a while, therefore I can't seem to wrap my head around it:
I have a longevity database. An employee who stays in a position for 5 years + earns a specific amount of longevity pay depending on how long he/she is in the position.
.05 - >=5 years but <10 years
.10 >=10 years but <15 years
.15 >=15 years but <20 years
.20 >=20 years but <25 years
.25 >=25 years
Of course if the employee leaves the position for any other reason than a promotion, then he/she loses that longevity pay. I've solved that problem with a yes/no (true/false) checkbox. The box is unchecked, then he/she is eligible for longevity, etc.
I have date add fields in a query to tell me what the dates are for each 5 year increment.
I have a form that I can enter specific dates into to show which ones are currently due, but of course, it shows me all of the dates in each of the 5 year, 10 year, 15 year, etc. columns. I only want to see which specific dates that I've entered the criteria for.
I would love if this could be automatically done with the push of a button. i.e. today + 7 days (report)
Any suggestions - am I even close or on the right track??