I have one table with training dates, names, courses etc in it. Another has dates when training should be completed, which is different for everyone. Training has to be done 1 year prior to entering their time frame.
Currently I have a query that shows
which shows everyone who is within 60 days of being due. and another criteria under CourseName for each course.
How do I write the query to give me the information I need?
Code:
Training Table:
Name, LastCompletionDate, CourseName
TimingTable:
Identifier, Start Date, End Date
Currently I have a query that shows
Code:
LastCompleteDate criteria "< Date() - 305"
How do I write the query to give me the information I need?