alktrigger
Aimless Extraordinaire
- Local time
- Today, 13:58
- Joined
- Jun 9, 2009
- Messages
- 124
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
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