Merging to flat file

[simmel]

Please help? I don't know how to do this in Access or SQL?

To keep it simple here is a table called Scores

ID Number Value
1 5
1 6
1 10
2 7
2 8

What I want to output via a query is (I will comma deliminate it)

1,5,6,10
2,7,8

So it has one instance of the ID number and then all the values in a flat file. The number of fields can vary.

Can someone help??

Thanks...