Thanks!!! It worked great!

>Try this:
>SELECT Action.Idno, EmpMast.Surname, Last(Action.Desc) AS DernierDeDesc, Max(Action.EffDate) AS MaxDeEffDate
>FROM EmpMast INNER JOIN Action ON EmpMast.IDNO = Action.Idno
>GROUP BY Action.Idno, EmpMast.Surname;