Value in Crosstab Query

  • Thread starter hongluen via
  • Start date

hongluen via

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.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question