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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Populating the many side of a 1 to Many relationship 2
Access 2003: Need module to add dates to report. 2
Access SQL - Most recent child record 5
Filter by date in query 8
last date attended query 1
Search a data (EmployeeName) from all the tables in the database m 7
How to build a "reach around" query? 5
Help with Iif on Report 4

Back
Top