Hi,

This is a classic problem in SQL, that is generally solved with a self-join.

SELECT Main.*
FROM MyTable Main
JOIN (SELECT Emp#, Code, Max([Expiration Date]) AS MaxDate
          FROM MyTable
          GROUP BY Emp#, Code) Filter
ON Main.Emp# = Filter.Emp#
AND Main.Code = Filter.Code
AND Main.[Expiration Date] = Filter.MaxDate


There is also another trick you can use in Crystal, if you don't mind bringing in all the data and just suppressing what you don't need.  Create groups, in this case, on Emp# and Code.  Put a suppression criteria on the details section that looks like:

{MyReport.[Expiration Date]} <> Maximum ({MyReport.[Expiration Date]},{MyReport.Code})