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

kost36 at otenet.gr kost36 at otenet.gr
Sat Jan 27 06:00:24 CST 2018


solved with crystal's  precious help on experts-exchange...
 
https://www.experts-exchange.com/questions/29080319/Help-on-Patrick-Matthews
-DConcat-function.html

thank's you all too


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

Yes Bill, it means 2 dogs

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

Spot, Rover (dog) means 2 items with (dog) or a single dog? If

On Jan 24, 2018 3:19 PM, <kost36 at otenet.gr> wrote:

> 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
>
> --
> 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



More information about the AccessD mailing list