I want to modify the query below, which I use in my Access2007 application. I want the query to only return the latest test taken base on the DateTaken field. So if a student has taken the same test three times, I only want the query to return one record (the latest record based on a Date field). How can I do this?
SELECT * FROM TestsTaken WHERE [StudentID] = 100 AND [TestName] = 'WeeklyExam'
Thanks in advance,