Dance students enter the studio and enter in their ID. (Note: the date and time fields are automatically filled in with the correct values.) Students are allowed to attend once a day.

Issue: I need to run a report where I display the students name and the last date attended. I'm able to search and find the student's attendance records and sort by date. I cannot figure out how to display only the latest date (most recent)

Thanks for any help.

M

use Max(date) with ID as the break field.