Array & RecordSet Help Needed

[Nix]

hi all,

Can i know any method that i can do to combine 2 array??
or
Any method to combine RecordSet together.

[Roelf]

Function JoinArrays (ByVal inpArray1, ByVal inpArray2)
JoinArrays = array(Join(inpArray1, ","),Join(inpArray2, ","))
End Function

the function takes the arrays as arguments, it creates a string of each, where every element is separated form the next by a comma. the two strings are also separated with a comma and eventually, the whole string is turned back into an array

did not test it, but i think it will work