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

Bill Benson bensonforums at gmail.com
Wed Jan 24 14:52:13 CST 2018


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
>


More information about the AccessD mailing list