Student/lecture latest query

Lectures presented by all the students during the last year has been stored in a talbe named: studentlectures, with these fields : ID, studentname, lecturesubject, lecturedate
For example:
1, john, mathematics, 2/3/2012
2, jack, chemistry, 10/3/2012 ,
3,john, engineering, 15/3/2012
4,jack ,chemisty,20/3/2012
5,john,politics,30/3/2012
6,john,engineering, 15/4/2012
7,jack,politics,15/4/2012
We want a query to show the latest record for each student with a specific lecture. For the above example the result will be:
1, john, mathematics, 2/3/2012
4, jack , chemisty,20/3/2012
5,john, politics,30/3/2012
6, john, engineering, 15/4/2012
7, jack,politics,15/4/2012
Previous subject records by each student are not shown, and only the latest one is shown.
Thank you

there is an unanswered old cross link this question, but i was not allowed to post the link.

This should do the trick.

I wasn't sure what to do with ID and be aware that you will have multiple Johns and Jacks rolled together unless you add another field like StudentID to the query

Please Login or Register  to view this content.

thank you very much.
If my table had only three fields groupby would finelywork. In fact the real table has other fields, such as professorname,audiancenumbers, roomname, and else. If i make others "groupby" as well, i dont get only the last reacord for a given student/lecture. what should i do to other fields?

No problem - for a fuller answer please let us know what the output required is, and the field tgat you want to use from the source table(s)