= Access Concat Aggregation =
Here is an example where I want to concat several record fields over unique values in another field(s). In the case below I want to select distinct email and collect GenEd field.
SELECT DISTINCT I.[First Name], I.[Last Name], C.email, ConcatRelated("GenEd","[Distinct Email-GenEd]", "Email = '" & [C.Email] & "'") AS [Sections Taught]
FROM GE_Courses AS C, Contact_Info AS I
WHERE I.Email=C.Email;