0

I have the following table in Access (from a query):

Ref     Score
ET/21     7
ET/21     6
ET/21     7
ET/25     3
ET/25     5

I want to create another table from it (or do it in the query), where I have the following instead (i.e. all the values for each ref are in the same cell concatenated with ',' between:

 Ref     Score
ET/21     7, 6, 7
ET/25     3, 5

Is this even possible?

YowE3K
  • 23,852
  • 7
  • 26
  • 40
Nicholas
  • 3,517
  • 13
  • 47
  • 86
  • 1
    You're looking for the equivalent of MySQL's `GROUP_CONCAT()` function, which does not exist in Access. One workaround would be to write a custom function which does this, and you can read about that [here](http://stackoverflow.com/questions/2852892/is-there-a-group-concat-function-in-ms-access). – Tim Biegeleisen May 16 '17 at 09:03
  • Excellent, thank you Tim! Much appreciated... I will check it out – Nicholas May 16 '17 at 09:17
  • I found a easy way to do it in Python, going to do it there instead :) – Nicholas May 16 '17 at 09:27
  • Thank you, I will check it out! – Nicholas May 16 '17 at 09:59

0 Answers0