Value in Crosstab Query

[hongluen via AccessMonster.com]

Can I show all the data or merge them into one single cell,
instead of doing any aggregate functions such as sum and average,
in a Crosstab Query?

To illustrate my question:
StudentID TestID Score (Date)
AAA 1 50 (date1)
AAA 1 60 (date2)
AAA 1 55 (date3)
AAA 2 23 (date2)
AAA 2 24 (date4)
AAA 3 98 (date4)

I want to show the data in a Query or Report in this way:
StudentID Test1 Test2 Test3
AAA 50 (date1) 23 (date2) 98 (date4)
60 (date2) 24 (date4)
55 (date3)

I worked out a Crosstab Query, but it allows to show only the First or the
Last record.

 

[Guest]

You can use the generic concatenate function found at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane as the
value.