For every client, many of the same document will be created. I am trying to show only the maximum date for the document for each client. I tried using maximum(MTP_Master.Revision_StartDate, FD_Clients.Fullname), however I must group the patient's by name. I don't want to do that as I want to be able to sort by the revision start date rather than by the patient's name. Does anyone know anyway to do this?