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

Jim Dettman jimdettman at verizon.net
Wed Jan 24 13:33:53 CST 2018


 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



More information about the AccessD mailing list