Как группировать все оценки и предметы в одну строку, с запятыми?

  SELECT student.id, student.fio, student.klass, student.data_ocen,
 FIRST([student].predmet) & 
IIf(COUNT([student].predmet)>1,"," & LAST([student].predmet)) AS Сообщение
 
FROM student
GROUP BY student.id, student.fio, student.klass, student.data_ocen
;

SELECT qT.FIO, qT.nom\2+1 AS nom, qT.BLOCK & IIf(qT_1.BLOCK & ""="","",qT_1.BLOCK) AS BLOCK
FROM qEx4 AS qT LEFT JOIN qEx4 AS qT_1 ON (qT.nom=qT_1.nom-1) AND (qT.FIO=qT_1.FIO)
WHERE (qT.nom MOD 2)=1;

SELECT DISTINCT student.id, student.FIO, student.klass, 
  iif(R1.predmet_id=1,R1.ocen,"") & 
  iif(R2.predmet_id=2,R2.ocen,"") & 
  iif(R3.predmet_id=3,R3.ocen,"") & 
  iif(R4.predmet_id=4,R4.ocen,"") & 
  iif(R5.predmet_id=5,R5.ocen,"") & 
  iif(R6.predmet_id=6,R6.ocen,"") & 
  iif(R7.predmet_id=7,R7.ocen,"") &
  "" AS RESULT
FROM (((((((
student
 LEFT JOIN RESULT AS R1 ON (student.id = R1.student_id AND (R1.predmet_id=1 OR R1.predmet_id IS NULL)))
 LEFT JOIN RESULT AS R2 ON (student.id = R2.student_id AND (R2.predmet_id=2 OR R2.predmet_id IS NULL)))
 LEFT JOIN RESULT AS R3 ON (student.id = R3.student_id AND (R3.predmet_id=3 OR R3.predmet_id IS NULL)))
 LEFT JOIN RESULT AS R4 ON (student.id = R4.student_id AND (R4.predmet_id=3 OR R4.predmet_id IS NULL)))
 LEFT JOIN RESULT AS R5 ON (student.id = R5.student_id AND (R5.predmet_id=5 OR R5.predmet_id IS NULL)))
 LEFT JOIN RESULT AS R6 ON (student.id = R6.student_id AND (R6.predmet_id=6 OR R6.predmet_id IS NULL)))
 LEFT JOIN RESULT AS R7 ON (student.id = R7.student_id AND (R7.predmet_id=7 OR R7.predmet_id IS NULL)))
;

SELECT DISTINCT student.id, student.FIO, student.klass, 
  iif(R1.predmet_id=1,R1.ocen,"") & 
  iif(R2.predmet_id=2,R2.ocen,"") & 
  iif(R3.predmet_id=3,R3.ocen,"") & 
  iif(R4.predmet_id=4,R4.ocen,"") & 
  iif(R5.predmet_id=5,R5.ocen,"") & 
  iif(R6.predmet_id=6,R6.ocen,"") & 
  iif(R7.predmet_id=7,R7.ocen,"") AS RESULT
FROM (((((((
(student INNER JOIN ozenka ON student.id=ozenka.student_id)
 LEFT JOIN RESULT AS R1 ON (student.id = R1.student_id AND (R1.predmet_id=1 OR R1.predmet_id IS NULL)))
 LEFT JOIN RESULT AS R2 ON (student.id = R2.student_id AND (R2.predmet_id=2 OR R2.predmet_id IS NULL)))
 LEFT JOIN RESULT AS R3 ON (student.id = R3.student_id AND (R3.predmet_id=3 OR R3.predmet_id IS NULL)))
 LEFT JOIN RESULT AS R4 ON (student.id = R4.student_id AND (R4.predmet_id=4 OR R4.predmet_id IS NULL)))
 LEFT JOIN RESULT AS R5 ON (student.id = R5.student_id AND (R5.predmet_id=5 OR R5.predmet_id IS NULL)))
 LEFT JOIN RESULT AS R6 ON (student.id = R6.student_id AND (R6.predmet_id=6 OR R6.predmet_id IS NULL)))
 LEFT JOIN RESULT AS R7 ON (student.id = R7.student_id AND (R7.predmet_id=7 OR R7.predmet_id IS NULL)))
UNION SELECT student.id, student.FIO, student.klass, "" FROM student WHERE FALSE;