how do I query on same students with different dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a query that outputs to MS access, this query has all the last dates
for students on different courses, I'm wanting to pull out a list of students
with their last dates they attended.

i.e. Mark jones | psychology | 23-nov-2004
Mark Jones | psychology | 24-nov-2004

I vant a query just to display : Mark Jones | psychology | 24-nov-2004
 
Try that query

SELECT Name, Course, Max(Format([DateAttend],"dd-mmm-yyyy")) AS
Last_DateAttend
FROM MyTable2
GROUP BY Name, Course
 
Back
Top