Aggregate Row String Concatenation in MS Access

[NewsBot]

Does anyone know how to perform an aggregate string concatenation in Microsoft Access without using a VBA module? I want pure SQL.

 

Across columns of a table is easy. Ex:

 

People

 

Id* Name* Dob

1** John**1/2/1975

2** Bob** 1/2/1975

3** Tim** 5/7/1955

 

MS Access SQL:

 

SELECT p.Id, (p.Name & ' ' & p.Dob) AS Person

FROM People p

 

I have no idea how I would go about concatenating rows. Does anyone have experience with that?

 

Ex: Get a comma-delimited list of people with the same birthday

 

Results should look like this:

 

Dob*******People

1/2/1975* John, Bob

5/7/1955* Tim

 

Thanks for the help.

 

More...

 

View All Our Microsoft Related Feeds