layout

[Rob]

Keeping track of test results, I have a database containg two related
tables - Names and Scores (one person may have more than one score).

Using a query to find names and their scores this is the result:

John 9
John 7
John 5
Fred 8
Fred 6

Is it possible to change this layout to

John 9, 7, 5
Fred 8, 6

using some sort of Report?

Thanks - Rob

 

[Douglas J. Steele]

Take a look at http://www.mvps.org/access/modules/mdl0004.htm or
http://www.mvps.org/access/modules/mdl0008.htm at "The Access Web" for a
couple of ideas.

 

[David Cox]

a crosstab query could do something like this, but you would get one column
per score. This could be a useful side effect, (eg who scored 7) which is
why I mention it.