Most Recent Data from a Date

[isapple]

I have a problem here that I've been wrestling with for a while.

I have a table, ID, Date, and Grade.
It is set up that way, and I tried

SELECT tblGrades.StudentID, tblGrade.Grade, Max(tblGrade.GradeDay)
FROM tblGrades
GROUP BY tbGrades.StudentID, tblGrades.Grade;

I figured since I'm grouping by both StudentID and Grade, it wont return the most recent grade from that Student. Is there any way for me to NOT group by Grade and just display the results of the Max(GradeDay?)

 

[pbaldy]

One way:

http://www.baldyweb.com/LastValue.htm