I spent the last 3 days trying to get this to work. My final report is complete and I have 2 subreports that I only want to display the most recent record. It is displaying all the records. I've tried SELECT TOP 1, I've tried sorting with a query (DESC). I sure would apprecitate any help.