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

[Ryan W]

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
>