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

[Ryan W]

Maybe look into Allen Browne's ConcatRelated?

http://allenbrowne.com/func-concat.html

On Wed, Jan 24, 2018 at 12:55 PM, <kost36 at otenet.gr> wrote:

> 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
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>