G
Guest
I need a column in my query to display a list of values returned from a
subquery. No problem if the subquery only returns a single value, or if I
alter it to return an aggregate value like COUNT. But I get the message "At
most one record can be returned by this subquery" when I try to have it
return multiple values.
There are never more than 3 matches (but there could be 0, 1, 2 or 3
matches), and what I really need is to return a comma-separated list of the
text values found by the subquery (like "Name1, Name2, Name3") as a string or
text value of some sort (any type of delimiting should suffice).
The subquery is defined as the FIELD value for the column in my primary
query, and looks like the following:
OtherServiceLines: (SELECT [ServiceLines].[ServiceLineName]
FROM [ServiceLines]
WHERE [CurrentID] = [ServiceLines].[Sales_ID])
Any ideas on how to get a column to contain a list of values obtained via a
subquery or is there another method to accomplishing this madness???
As always, THANKS for all your help!
subquery. No problem if the subquery only returns a single value, or if I
alter it to return an aggregate value like COUNT. But I get the message "At
most one record can be returned by this subquery" when I try to have it
return multiple values.
There are never more than 3 matches (but there could be 0, 1, 2 or 3
matches), and what I really need is to return a comma-separated list of the
text values found by the subquery (like "Name1, Name2, Name3") as a string or
text value of some sort (any type of delimiting should suffice).
The subquery is defined as the FIELD value for the column in my primary
query, and looks like the following:
OtherServiceLines: (SELECT [ServiceLines].[ServiceLineName]
FROM [ServiceLines]
WHERE [CurrentID] = [ServiceLines].[Sales_ID])
Any ideas on how to get a column to contain a list of values obtained via a
subquery or is there another method to accomplishing this madness???
As always, THANKS for all your help!