I知 running into a issue with a query that I could use some help on. I知 building a database in Access to capture the completion of recurrent training, typically training that needs to be completed on an annual basis. One of the actions I need to perform is to review training records, return the latest record for each employee by training module, and then verify if the completion date is within the last year.
I created a query that returns training records for each employee, converted it to a totals query using Last as a filter on the completion date. So if an employee has tow or more records for the same course I only see the latest one. So far working as intended.
Next I created a field that evaluates the completion date using the following IIf statement
Code:
Standing: IIf(([Completion Date]+[Recurrency])>Now(),"Current","Overdue")
The statement works, but it breaks my Last filter, and I知, back to seeing all of the employees training records, not just the most recent one.
Any ideas on how I should proceed?