most recent date in query

B

Bill H.

I have a query where the results include a student's ID number and dates of
attendance.

What I need is a way, via the query, to return only the date of last
attendance.

How do I do that?
 
S

Steve Schapel

Bill,

In design view of the query, make it a Totals Query (select Totals from
the View menu). In the Totals row of the query design grid, leave it
set to Group By in the StudentID column, and enter Max in the
AttendanceDate column.
 
Top