New Access user here. I have a simple datebase containing employee information. I have 3 differents dates which reflect the DUE date for a qualification that each employee needs in order to continue working on the job site.
I have looked at other postings but see nothing similar to what I am needing.
I need to simply have a flag (colour change or text) to alert a user that the current date is within a 30 day window prior to the due date.
In other words a warning that warns when that employee is 30 days away from requalification in each of the 3 categories.
Someone suggested just running a query and find dates between this date and 30 days from now, but this seems kinda silly.
Then again...what do I know?
Thanks in advance.