Report question

Question: Access SQL query: find the row with the most recent date for each distinct entry in a table