I would appreciate if anyone can help me filter this query to view only the latest date of assessment by Fullname. Currently it is displaying all records. I’m not sure how to use the MAX query on the date of assessment.

SELECT vdbrsac1_assessment.vdbrsac1_ClientID, ContactBase.FullName, ContactBase.BirthDate, vdbrsac1_assessment.vdbrsac1_AssessmentTypeName, vdbrsac1_assessment.vdbrsac1_KeyCompetency, vdbrsac1_assessment.rsa_job_registerName, vdbrsac1_assessment.vdbrsac1_EmploymentServiceName, vdbrsac1_assessment.vdbrsac1_DateofAssessment, vdbrsac1_assessment.CreatedByName, vdbrsac1_assessment.ModifiedOn FROM vdbrsac1_assessment INNER JOIN ContactBase ON vdbrsac1_assessment.vdbrsac1_Client = ContactBase.ContactId WHERE (vdbrsac1_assessment.vdbrsac1_AssessmentTypeName LIKE ‘%Wage%’) AND (vdbrsac1_assessment.vdbrsac1_AssessmentReviewStage = ‘676160006’ OR vdbrsac1_assessment.vdbrsac1_AssessmentReviewStage = ‘676160000’) AND (vdbrsac1_assessment.vdbrsac1_DateofAssessment IS NOT NULL) ORDER BY ContactBase.FullName

Thank you.