I have a table with events and dates. The events repeat, each record having a different date. How can I create a report that lists events by the latest date? I need something like max date for each event. I tried creating a field in the table with maximum event date, but that gives me the max event date in the table.