Howto? get multiple results into a single row...

[Reinhard]

Hi folks,

I'm trying the following:

there are two tables:
t1:feature-ID,feature,...
t2:customer-ID,customer,...,feature-ID,...

Now I want to have a query, which produces the following result:

feature-ID, feature, (customer-ID1, customer-ID2, customer-ID3,...)

My problem: I don't know how to establish the third row, which should
be a subquery itself, but I do not get the results of this subquery
into a sinle string to get the third row.

And no, I do not want multiple lines each beginning with the same
stuff and having a different customer-ID.

I tried it with SQL.

Can anyone help?

Thanx

Reinhard

 

[Allen Browne]

Simplest approach is to use a VBA function to concatenate the related values
into a string.

You can copy'n'paste such as function from here:
Concatenate values from related records
at:
http://allenbrowne.com/func-concat.html