Concatenation of detail-records in a Master-Detail relationship

[John Smith]

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?

 

[Allen Browne]

See:
http://www.mvps.org/access/modules/mdl0004.htm

 

[Duane Hookom]

There is a function and sample at
http://www.rogersaccesslibrary.com/OtherLibraries.asp. Search for "Generic
function to concatenate Child records".