Hello Everyone,
This more of a issue with my tired little brain than anything else.
I am creating an absence review meeting tracker for work. Its nearly complete and I'm just adding some additional features to make it easier for the end user.
When we issue a sanction it lasts for six months from the absence review meeting date. So on the form i have a dropdown combobox with for example "6 months warning" when this is selected i want to automatically populate a date 6 months from the date of the absence review meeting that is already populated with a date.
Also......
I want to create a report which shows which sanctions are live. So if the absence review meeting is 11/09/2022 and the sanction date was 6 months from this date 11/03/2022. I would like it to show if the date is within these 2 dates and is active. I hope everyone understands this.
Thanks for your help in advance, its only my 3rd database i have created and I've really enjoyed it and it will enhance our current processes and procedure's. Everyone has to start somewhere!!
This more of a issue with my tired little brain than anything else.
I am creating an absence review meeting tracker for work. Its nearly complete and I'm just adding some additional features to make it easier for the end user.
When we issue a sanction it lasts for six months from the absence review meeting date. So on the form i have a dropdown combobox with for example "6 months warning" when this is selected i want to automatically populate a date 6 months from the date of the absence review meeting that is already populated with a date.
Also......
I want to create a report which shows which sanctions are live. So if the absence review meeting is 11/09/2022 and the sanction date was 6 months from this date 11/03/2022. I would like it to show if the date is within these 2 dates and is active. I hope everyone understands this.
Thanks for your help in advance, its only my 3rd database i have created and I've really enjoyed it and it will enhance our current processes and procedure's. Everyone has to start somewhere!!