Concatenation Via Query?

[jt463]

I was trying to do this via VB, but after reading a few of the threads in this forum, I think that with some help I may be able to accomplish what I want via SQL.

I am querying a schedule table with the following SELECT statement:

SELECT building_id_, activity_name_, start_date_

Which returns data like:

086, install appliances, 5/2/06
086, install floor, 5/2/06
086, plumbing finish, 5/3/06
086, HVAC finish, 5/3/06
086, clean home, 5/4/06

I want to concatenate all activities for the same date into one field, separated by a ',' (comma).

So, I want my result to be:

086 install appliances, install floor 5/2/06
086 plumbing finish, HVAC finish 5/3/06
086 clean home 5/4/06

I am stumped! Your time and assistance would be greatly appreciated.

 

[lespaul]

FAQ701-4233

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases: The Fundamentals of Relational Database Design