Script that selects certain files

[faaslave]

I am not sure how to go about getting the result I want in my script. The answer is probably not in the script itself, so if I am in the wrong category, I apologize.

I have employee's that have numerous records pertaining to Sick Leave. When I run the report using this script, it will give me all the records, for all the employees. This works fine.

There is a field called "type". Examples of this are:

sick leave reviewed

sick leave letter issued

sick leave warning

So what I would like to do, is to be able to run a report, that will only give me the most recent record for each employee of any type. So if an employee has 5 records with reviewed, 2 under letter issued, and 3 with a warning, I would get the most recent of these only.

Resulting in:

Dave sick reviewed

Dave sick leave letter issued

Bill sick leave reviewed

Jane sick leave reviewed

I think I need a new TO with the correct relationship between the employee table and the sick leave table. I just don't know how to go about doing this.

Any help would be appreciated as usual.

Dave