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

[kost36 at otenet.gr]

Not exactly Ryan,
I am looking for 

Lastname | exp1
Hookom   | Bob(Dad), Anne(Mom), Timmy (Son), Spot, Rover(Dog) Cranky,
Biscuit(Cat)

Group by role if exists more than one




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

Isn't this what you're looking for?

https://i.imgur.com/ymHsnRo.png

Here's my code using ConcatRelated


SELECT Table1.LastName, ConcatRelated("[FirstName] & '(' & [Role] &
')'","Table1","LastName = '" & [LastName] & "'") AS Expr1 FROM Table1;




On Wed, Jan 24, 2018 at 1:33 PM, Jim Dettman <jimdettman at verizon.net> wrote:

>
>  Think that would depend more on the table/query design.
>
> Another Concat function:
>
> https://www.experts-exchange.com/articles/2380/Domain-
> Aggregate-for-Concaten
> ating-Values-by-Group-in-Microsoft-Access.html
>
> Jim.
>
> -----Original Message-----
> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf 
> Of kost36 at otenet.gr
> Sent: Wednesday, January 24, 2018 1:56 PM
> To: 'Access Developers discussion and problem solving'
> Subject: [AccessD] Concatenate seaparated by " ," and group by
>
> 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
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com