Microsoft Access combine like rows based on two columns

Question

I would like to combine like rows based on StudentID and Subject in the table below.

StudentID	Subject	Code
393438	Math	[AF15]
393438	Math	[DS1.4]

I would like for the code column to join the unique values into one field. Example: The above table would become:

StudentID	Subject	Code
393438	Math	[AF15];[DS1.4]

I have tried to merge the table with another table with unique records for studentid and subject. I am fairly new at MS Access and still learning. Any help would be greatly appreciated.

Does this answer your question? [Allen Browne's ConcatRelated() Error 3061: Too few parameters](https://stackoverflow.com/questions/54789423/allen-brownes-concatrelated-error-3061-too-few-parameters) — June7, May 11 '23 at 17:28

score 1 · Answer 1 · answered May 11 '23 at 19:55

1

Use my fast function DJoin:

SELECT 
    Student.StudentID, 
    Student.Subject, 
    DJoin("[Code]","Student","",";") AS Codes
FROM 
    Student
GROUP BY 
    Student.StudentID, 
    Student.Subject;

Output:

answered May 11 '23 at 19:55

Gustav

53,498
7
29
55

Microsoft Access combine like rows based on two columns

1 Answers1