I have a simple report that shows me all my vendors. I group them by vendor id and name. We rate these vendors as unacceptable, satisfactory, good and excellent. When I run the report I get all records for each vendor and the date the rating was entered. I would only like to see the most recent rating. Is there a simple way to do this?