I have the following query, which I want to return ONLY the most recent test date:
But it is giving me all the test dates for each student when I only want the latest.
Code:
SELECT qryTestingMostRecentTest.StudentFileName, Last(qryTestingMostRecentTest.TestDate) AS LastOfTestDate, qryTestingMostRecentTest.NextForm, qryTestingMostRecentTest.Class
FROM qryTestingMostRecentTest
GROUP BY qryTestingMostRecentTest.StudentFileName, qryTestingMostRecentTest.NextForm, qryTestingMostRecentTest.Class;
But it is giving me all the test dates for each student when I only want the latest.