I have two tables; tblLoop and tblEvents. tblEvents contains events related to a record in tblLoop. I want to be able to search tblEvents and find any event categorized as PM within the last year that relates to a record in tblLoop.
If a result is found I want to write a string to a field called Maintained in tblLoop.