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

[Ryan W]

I should have added "SELECT DISTINCT" but I was just going for what you
needed in a concatenation, I think.


On Wed, Jan 24, 2018 at 2:06 PM, Ryan W <wrwehler at gmail.com> wrote:

> 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-Aggreg
>> ate-for-Concaten
>> ating-Values-by-Group-in-Microsoft-Access.html
>> <https://www.experts-exchange.com/articles/2380/Domain-Aggregate-for-Concatenating-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
>>
>
>