Combining Grouped Records (1 Viewer)

[alktrigger]

I have a query dumping into a table which is used to generate a report. Under certain circumstances, nearly duplicate entries appear in the table, the only difference being in 1 of the 16 columns. That one column is a text field titled "issues". Is there a way to write a query that will combine the texts fields together in a string format.

The following is a example of what i am trying to achieve. What would be the best way of approacing this problem?

Before:
Name ..... Issue
A ....... old
B ....... broken
B ....... old
C ....... dead

After:
Name ..... Issue
A ...... old
B ...... broken, old
C ...... dead

 

[HiTechCoach]

This may help:

Return a concatenated list of sub-record values