1. Create a new student query
     
  2. On the Criteria tab, select Student, Student Progression Entry, Academic Year equals [year]
     
  3. Create a new student query
     
  4. On the Criteria tab, select Courses, Academic Year equals [year]
    AND Course, Course name not blank
     
  5. Merge the Queries. Select Records Included in Query 1, but Exclude Records Included in Both Queries