Yet another basic SQL question

I have the following statement that is intended to provide the most
records with the most recent status from the SAF2 table, based on
dbo.SAF2_Status.ActionDate along with the corresponding record from
the SAF2_Pay table.  However, it is yielding more than just the most
recent record....it is providing multiple statuses of records when I
only want the most recent one.  This, in turn, is creating duplicates
from the SAF2_Pay table since it is joining on duplicated.

I only want to yield the most record status...it should be grouped by
CESAFID but I cannot get it to work.

Any assistance would be appreciated.




SELECT     dbo.SAF2_Status.ActionDate, dbo.SAF2_Status.CESAFID,
dbo.SAF2_Status.Status, dbo.SAFs.CESAFID AS Expr1, dbo.SAFs.Term,
dbo.SAFs.CRN, dbo.SAFs.Subj, dbo.SAFs.Crse, dbo.SAFs.SubjOther,
dbo.SAFs.Course_Title, dbo.SAFs.Site, dbo.SAFs.SiteOther,
dbo.SAFs.Inst1, dbo.SAFs.Inst2, dbo.SAFs.NewInstructor, dbo.SAFs.CH,
dbo.SAFs.Dept, dbo.SAFs.Cap, dbo.SAFs.Mode, dbo.Faculty.LastName AS
[1Lname], dbo.Faculty.FirstName AS [1Fname], dbo.SAF2_Pay.PayTotal,
dbo.SAF2_Pay.NumOfPays, dbo.SAF2_Pay.PayDates, dbo.SAF2_Pay.Fund,
 dbo.SAF2_Pay.Org, dbo.SAF2_Pay.Acct, dbo.SAF2_Pay.Program,
dbo.SAF2_Pay.Dept AS PayDept
FROM  dbo.SAFs INNER JOIN dbo.SAF2_Status ON dbo.SAFs.CESAFID =
dbo.SAF2_Status.CESAFID INNER JOIN dbo.SAF2_Pay ON dbo.SAFs.CESAFID =
dbo.SAF2_Pay.CESAFID LEFT OUTER JOIN dbo.Faculty ON dbo.SAFs.Inst1 =
dbo.Faculty.EID
WHERE     (dbo.SAF2_Status.ActionDate =
                          (SELECT     MAX(ActionDate) AS Expr1
                            FROM          dbo.SAF2_Status AS
SAF2_Status_1
                            WHERE      (dbo.SAF2_Status.CESAFID =
dbo.SAFs.CESAFID)))