A starting point:
SELECT A.*
FROM yourTable A INNER JOIN (
SELECT TrainingCode, MAX(StartDate) AS MaxDate FROM yourTable GROUP BY TrainingCode
) B ON A.TrainingCode = B.TrainingCode AND A.StartDate = B.MaxDate

Hope This Helps, PH.
FAQ219-2884: How Do I Get Great Answers To my Tek-Tips Questions?
FAQ181-2886: How can I maximize my chances of getting an answer?

I am fairly new to crystal and not very tech language savvy. Currently I have one Group on my report, and it is by employee. So while the info provided above looks like it would work, I am still not sure how to accomplish the coding provided. It seems to me that I need to create a group based on the training code and go from there. I am not really wanting to create any more groups because they like the way the report looks now.

Thanks for your help!

You asked in the ANSI SQL forum, so I provided you an SQL code that does what you want without any Crystal stuff.
What is your actual SQL code used as the data source of your report ?

Hope This Helps, PH.
FAQ219-2884: How Do I Get Great Answers To my Tek-Tips Questions?
FAQ181-2886: How can I maximize my chances of getting an answer?