Discussion Locked

Display Table Data Horizontaly

0 helpful
0 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

0 replies

No replies were posted before this discussion closed.

This discussion is closed to new replies.