[RESOLVED] Complex Issue with DataSet/Access

[masteripper]

Well i have a rather unsual case and i can't think of anything .
The situation is like this
I have a nice Access query that gathers info from various tables .SO far so good.The problem is that this queryis base for another query that has a calculated column that works with a custom function i have made in vba.
Lets assume the base query give this data

--------------------------------------------------
Client Order | Create Something with Code | Client
1x......................... | x01....................... | A
2x......................... | x01...................... |A
3x......................... | x02...................... |A
4x......................... | x03...................... |B

the calculated goes like this

--------------------------------------------------
Client OrderCalc | Create Something with Code | Client
1x / 2x ............| x01 ..................................| A
3x ..................| x02 ..................................|A
4x ..................| x03 ..................................|B (the dots are for "trying" to give proper column effect)


As u can see since the product i am going to make is the same in 2 orders i will make it once but i want the information that 2 client orders need it
Well right in VB i have a datagridview wich has source a dataset which is filled from a query which gets column(Create Something with code and Client,3 rows as u see in the calculated query but missing the 1st column) and i am trying to find a way to retrieve the 1st column.
I know it is a bit complicated and i am stuck.

P.S the custom function i use in VBA goes like this
For every row (the create something with code is Unique) in the calculated query it searches the base query for matching client orders and outputs a string with concatenated the clientOrders