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

kost36 at otenet.gr kost36 at otenet.gr
Wed Jan 24 13:09:13 CST 2018


Tried it too but with no luck 😊

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Ryan W
Sent: Wednesday, January 24, 2018 9:00 PM
To: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Subject: Re: [AccessD] Concatenate seaparated by " ," and group by

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




More information about the AccessD mailing list