VB logic

[kirubagari]

Hi,

I have a set of data
Number Path
1,2,3,4,5,6 Employee
2,3,4,6 Employee

There is 2 column in db.I need to check if the path is same name ,i need to combine the number.
1,2,3,4,5,6,2,3 ,4,6.
Kindly help.

   If colVIDRemark <> 0 Then
         Set dicVIDRemark = colVIDRemark.Item(i)
         strRemark = dicVIDRemark.Item(KEY_PATH)
         End If

[Rabbit]

Return a record set that's sorted by the Path and then loop through the records and append the Number together when the Path is the same.

[kirubagari]

Hi ,
Could you show me the logic.Need some help.

[Rabbit]

My post lays out the logic needed. What you want is an implementation and I don't normally do that unless the poster has shown an attempt at the logic I lay out.