Concatenation of detail-records in a Master-Detail relationship

Concatenation of detail-records in a Master-Detail relationship

Post by John Smit » Sat, 15 Nov 2003 05:24:20


Hi,

I have two tables (master-detail):

Table 1: Department
Dep_Id: Integer
Name: Text

Table 2: Employee
Emp_Id: Integer
Dep_Id: Integer
Name: Text

I want to make a query with two columns.
Column_1 : The Department
Column_2 : A combination (concatenation?) of all the employee's from the
department

For instance, this could be the result:

Sales : John, Paul, George, Ringo
Prod : Bill, Mick


Can anyone help me make this query?
 
 
 

Concatenation of detail-records in a Master-Detail relationship

Post by Allen Brow » Sat, 15 Nov 2003 12:59:00

See:
http://www.yqcomputer.com/

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://www.yqcomputer.com/
Reply to group, rather than allenbrowne at mvps dot org.

 
 
 

Concatenation of detail-records in a Master-Detail relationship

Post by Duane Hook » Sat, 15 Nov 2003 13:08:25

There is a function and sample at
http://www.yqcomputer.com/ "Generic
function to concatenate Child records".

--
Duane Hookom
MS Access MVP