Jump to content

MS Access Concatenate rows into one field via sql


cobusbo
 Share

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?

Link to comment
Share on other sites

This thread is more than a year old.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • 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.