[AccessD] Concatenate seaparated by " ," and group by

kost36 at otenet.gr kost36 at otenet.gr
Wed Jan 24 12:55:51 CST 2018


Dear all,
Does anybody have ever used any kind of any concatenate function supporting
"group by" in the same record too?
Something familiar with what I need is Duane Hookom's, 2003 Concatenate
function specially his example on the query Example of First Names and Roles
in Family 
SELECT tblFamily.FamID, tblFamily.famLastName, Concatenate("SELECT FirstName
& ' (' & Role & ')' FROM tblFamMem  WHERE FamID =" & [FamID]) AS FirstNames
FROM tblFamily;)

which returns 

FamID |  famLastName	| FirstNames
1          |	  Hookom	| Duane (Dad), Laura (Mom), Jake (Son),
Chelsey (Daughter), Dakota (Dog), Josie (Cat)
But what about if there are more than one Son or more animals?

What I really need is very close to it but a little different
So, I have to concatenate all the crew of a movie grouped by people
specialty e.g.

Title	| crew
Title1	| (Director:) name1, name2 if exist (Actor:) name3, name4, name5....

Title2	| (Director:) name6 (Actor:) name7, name8, name9, (Script:) name10,
name11

I would appreciate it very much if you could help on that.
Thank's a lot

/kostas



More information about the AccessD mailing list