I have a query which concatenates three fields into a single result. Here's query field expression: E1: [C1] & " " & [C2] & " " & [C3]
C1 C2 C3
F1 - Swen Jill Tommy
F2 - Robert Jenny Bill
F3 - Gant Kelly Andy
Query Result
F1 - Swen Jill Tommy
F2 - Robert Jenny Bill
F3 - Gant Kelly Andy
My problem is I need to perform one more concatenation so that the query results to be listed on the same line separated by commas like the example below.
Example
Swen Jill Tommy, Robert Jenny Bill, Gant Kelly Andy
Thoughts?