Karend440

Finding most recent date of training item by employee and training type

Discussion created by Karend440 on Aug 19, 2016
Latest reply on Aug 22, 2016 by Karend440

Hello.. not sure about how to go about this.

I have a set of training records for employees.  The file is based on the Employee record (name, position, etc) and related to a table that contains their training records. The training records table has different types of training, some with expiration dates.

What I need to do is to be able to run a report that shows the most current date for that particular training, grouped by training name with the employees name on it. For example:

 

Training on :           Name:                Expiration date:

CPR                        PersonA           01/14/2013

CPR                        PersonA           01/14/2011

CPR                        PersonB           02/13/2013

Driving                    PersonB           02/14/2015

CPR                        PersonB           03/15/2016

Report would end up finding the most recent date,  by Training type for each person, and grouped by training type. So, the end result based on the above would look like:

 

Training on :           Name:                Expiration date:

CPR                        PersonA           01/14/2013

CPR                        PersonB           03/15/2016

Driving                    PersonB           02/14/2015

 

I've tried using "Last" and "Max" functions but not getting the results, it still displays everything. I am not sure, do I need to accomplish this through another relationship type?

 

Thanks, for any help, I appreciate it.

Karen

Outcomes