Jump to content

MS Access Concatenate rows into one field via sql


cobusbo

Recommended Posts

Hi I'm currently having a problem with concatenation. My fields is as follow

 

Leerder ID - Van - Eerste Voornaam - Datum

120 - Botha - Peter - 15/02/2015

120 - Botha - Peter - 16/02/2015

121 - Jacobs - John - 17/02/2015

 

I want it to show as

Leerder ID - Van - Eerste Voornaam - Datum

120 - Botha - Peter - 15/02/2015 & 16/02/2015

121 - Jacobs - John - 17/02/2015

 

My current SQL code is as follow

SELECT [Leerder Afwesigheid].[Leerder ID], Students.Van, Students.[Eerste Voornaam], Count([Leerder Afwesigheid].Datum) AS CountOfDatum
FROM Students RIGHT JOIN [Leerder Afwesigheid] ON Students.ID = [Leerder Afwesigheid].[Leerder ID]
GROUP BY [Leerder Afwesigheid].[Leerder ID], Students.Van, Students.[Eerste Voornaam]
HAVING (((Count([Leerder Afwesigheid].Datum))>=5));

How can I change it to add another field Datums Afwesig with the concatenated info?

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.