SELECT DISTINCT Sitedata.id, Sitedata.site_name, Sitedata.resp_party, Sitedata.r1,; Sitedata.street, Sitedata.city, Sitedata.status, Sitedata.material,; Sitedata.date_rep, reports.recvdate, reports.respdate, reports.rptname; FROM ; events!Sitedata; LEFT OUTER JOIN events!reports ; ON sitedata.id = reports.id; WHERE ISBLANK(reports.respdate) = .T.; AND (Sitedata.status = "O" OR Sitedata.status = "M"); AND DATE() > reports.recvdate + 30 ; AND ISBLANK(reports.recvdate) = .F.; ORDER BY Sitedata.id; INTO CURSOR reviewer WITH thisform .WindowState = 2 ENDWITH BROWSE thisform.Visible = .F. WITH thisform .WindowState = 0 ENDWITH DO FORM frmexport.scx TO m.exportcheck IF m.exportcheck = "a" EXPORT TO C:\Temp\NoReviewer.xls TYPE xls ENDIF thisform.Visible = .T.I need to display only the report entry that has the most recent rcvdate as a lot of them have many reports. What would be a way to do this in a query. I can think of other ways, such as creating a flag in the reports table, but I am hoping not to take that route. This seems like it should be simple, but it isn't coming to me.