Here is my dilemma. I have report that lists multiple entries for each record and I want it to only list the most recent date for each record. Basically, I have a report that has an inspection date and a test date and what I want it to do is to look up the most recent inspection date, and if there are multiple entries of the same inspection date for a particular record, then I want it to list the one with the most recent test date. Only if there are multiple entries for the inspection date should it look at the test date. Therefore, I will have the most recent information for each record and no multiple entries. Does this make sense? The report is based off a query that contains three reports that are joined by the same primary key. I'm having trouble figuring out how to do this since the max function is not producing the results that I want.