Hi Guys and Girls
I am struggling to find a solution that I am sure is quite simple for someone more experienced than me with Microsoft Access.
I issue certificates and have a certificate table in Access.
I have fields called "DateCertificateExpires" and "Status".
At the moment I have to manually update the status field when the expiry date is reached. The Status field values are "Valid","Withdrawn,"Expired"
Is it possible for this "Status" field to update itself to "Expired" when the expiry date has been reached.
Any help would be appreciated.
Regards
Grant
I am struggling to find a solution that I am sure is quite simple for someone more experienced than me with Microsoft Access.
I issue certificates and have a certificate table in Access.
I have fields called "DateCertificateExpires" and "Status".
At the moment I have to manually update the status field when the expiry date is reached. The Status field values are "Valid","Withdrawn,"Expired"
Is it possible for this "Status" field to update itself to "Expired" when the expiry date has been reached.
Any help would be appreciated.
Regards
Grant