cobusbo Posted February 18, 2015 Share Posted February 18, 2015 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? Link to comment https://forums.phpfreaks.com/topic/294716-ms-access-concatenate-rows-into-one-field-via-sql/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.