most recent date in query

  • Thread starter Thread starter Bill H.
  • Start date Start date
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?
 
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.
 
Back
Top