I have a table with columns [ID] and [Assignment]. I want to reduce multiple rows associated with each [ID] to a comma separated row of [Assignment]s.
Database saved to 2010-2016 format.table i’m working in
Tried every example I could find but I feel like the aggregate functions are not supported in the Access version I am working in. I don’t want totals or counts. Just concatenated data from many rows to one row.
New contributor
Teri Ziemann is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.