list

[rizabdullah]

Hi Guys

I have a table, as below. What I would like to do is to be able to create a query and list values and table2 below. Any assistance please.
TABLE1
Test 10101 10105
Test2 10500 10505


Here is how I would like to see final output:
TABLE2
Test 10101
Test 10102
Test 10103
Test 10104
Test 10105
Test2 10500
Test3 10501
Test4 10502
Test5 10503
Test6 10504
Test7 10505

 

[arnelgp]

use union query:

select [test name], fnSplit([test number],1) from table
union
select [test name], fnSplit([test number], 2) from table;

put in module:

public function fnSplit(v as variant, i as integer) as variant
fnSplit=Split(v & ""," ")(i-1)
end function