I am currently trying to update my company's training log which is stored in access and am looking for some assistance. Two of the fields in the table are [Train Date] and [Expiration]. Unfortunately, most of the time [Expiration] has been left blank and I am seeking to add training expirations where necessary. To complicate this, some trainings expire after 1 year, some 3, some 5, and some do not expire at all so I am not able to make 1 change across the board with a calculated field or something of the sort. Is there any way that I would be able automate the process (with a query maybe?) so that I can, for example, add an expiration of 3 years after train date for all forklift trainings? I am not super fluent in access so if there is a simple fix that I am overlooking, that'd be awesome.
Thanks in advance!