Search results

Hi I have a database with customer ID and their answer as shown below. What I would like to do is create a query that will group by ID and show Answer separated by comma. Table ID Answer 1 a 1 b 2 a 2 b 5 a 5 b Query 1 a,b 2 a,b 5 a,b Access does not support GROUP_CONCAT I think so I...