Topic: Concat Rows part 2... Posted: 25 Feb 2008 at 7:09pm
hello guys! i have another more problem... in my previous, i need to concatenate two(2) distinct item... here's my problem... what if there are two or more distinct item? here's an example...
IDNameTime In
1 Mike 8:00 2 Jim 8:50 3 Terry 9:00 1 Mike 9:09 1 Mike 9:10 1 Mike 9:20
i expect to have this result:
IDNameTime In
1 Mike 8:00, 9:09, 9:10, 9:20
2 Jim 8:50
3 Terry 9:00
Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Posted: 26 Feb 2008 at 12:28pm
You're going to have to make sure that your data is grouped/sorted so that all of Mikes records are together. You can then use the same method that was discussed in the previous post.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum