congegate multiple values to one record in query

[ElocinSnave]

Hello,

I am trying to have a query give me a congegation of multiple results in one
record.

Example:

With this query:

SELECT Employees.EmployeeID, ProfDesEmployee_Table.ProDesignation
FROM Employees INNER JOIN ProfDesEmployee_Table ON Employees.EmployeeID =
ProfDesEmployee_Table.EmployeeID;

I get:

EmployeeID ProDesignation
1 CFFA
2 CFFA
2 CPA
3 CISA
3 CISSP
5 CPA
6 CPA
7 CPA
7 JD

What I want to see is:

EmployeeID ProDesignation
1 CFFA
2 CFFA, CPA
3 CISA, CISSP
5 CPA
6 CPA
7 CPA, JD


Any help is appreciated!!!

Nicole

 

[Bob Barrows]

Hello,

I am trying to have a query give me a congegation of multiple results
in one record.

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

I believe Duane Hookom has a similar function available in Roger
Carlson's Access Library ... yes, here it is:
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=16