|
RE: Appending multiple fields to a single field
2/08/2007 9:51:17 AM
(Total replies: 1)
|
| Hi All,
wonder if anyone can help me with this one. I have a dataset that looks like this:
ID Note ID2 Date
01 a note 99 22/01/07
01 another note 92 25/01/07
05 note 32 27/04/07
05 a note 2 32 27/04/07
What I need to do is concatenate all notes together, either in a single field in seperate fields on the same line:
ID ... |
|