Concatenate Rows

[mp80237]

I have a table (below) and I need to concatenate the rows. I am using Microsoft 2010. I had something that was working but whent the company upgraded the query no longer worked. Below is the table.

thenumber number record_number description type
001A17070186 IM260201 1 Customer reported that they were receiving numerouscalls from agents who were being Executive Summary
001A17070186 IM260201 2 given a message to call security rather than beinggiven the template used to Executive Summary
001A17070186 IM260201 3 clear inhibited passengers. The problem was attributed to Information outages Executive Summary
001A17070186 IM260201 4 which occurred on 24JUN. These outgages prevented correct updating of security . Executive Summary


I need the outcome to look like this:
IM260201 Customer reported that they were receiving numerous calls from agents who were being given a message to call security rather than being given the template used to clear inhibited passengers. The problem was attributed to Information outages which occurred on 24JUN. These outgages prevented correct updating of security .

and I need only the records that have type "Executive Summary". Again I did have something before that was working, but is no longer. I have searched the net and cannot find a working query. Please help.

 

[mp80237]

I am tapping into a SQL database. For some reason they have the fields to all of the notes setup that way. I have read only access to it and cannot create views.