NewsBot
1
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
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