???
Here is a query--- InWhatYearsDid_YIN_Study.
With this result
This is a SELECT DISTINCT query to only show unique records.
Here is the sql behind the query graphic.
Code:
SELECT DISTINCT Student.StudentID, Student.StudentFName, Student.StudentLName, AcademicYear.OtherAcademicYearInfo
FROM Student INNER JOIN (StudentTookClassInYear INNER JOIN AcademicYear ON StudentTookClassInYear.AcademicYearID = AcademicYear.AcademicYearID) ON
Student.StudentID = StudentTookClassInYear.StudentID
WHERE (((Student.StudentFName)=[Enter Student FirstName]));
You will note that "Yin" attended for 1 semester/academic year.
In post #13, the display is for all students, all classes they studied.
Since Yin took 3 courses in 2-Fall 2007, the display shows values for the selected fields. The details are displayed for Yin's 3 records.
Good luck with your project.