I have a table that contains main scores and subscores in the same column (not my design, working with previous clients setup). I want to know if there is a way to display the TestScore field horizontaly and not vertical.
Example:
User TestType TestScore
001 0800 12
001 0800 14
001 0800 15
002 0700 6
002 0700 8
002 0700 11
I want it to look like the following using a query or something:
001 0800 12, 14, 15
002 0700 6, 8, 11
Any ideas on how this can be done? If it can be done at all? I am using Access 2003.
Thanks.
