Originally Posted by
Rendon115
Neither of these will work, but thank you
I don't have experience with Gicu's solution but based on your description of the problem Allen Browne's solutions certainly should work. Why don't you tell us what problems are you having trying to get those solutions to work? Or maybe you could elaborate on your problem further so we can understand why those solutions aren't suitable?
Here is example usage of Allen Browne's function (tested, looks like it works to me):
Code:
SELECT ExTable1.Type,
ConcatRelated("ExTable2.Color",
"ExTable2 INNER JOIN ExJunction ON ExTable2.ID = ExJunction.ColorID",
"ExJunction.TypeID=" & [ExTable1].[ID],
"ExTable2.Color",
", ") AS Colors
FROM ExTable1;