Text in a crosstab query? (1 Viewer)

Hi

I have created a simple query to show pattern requests from a trade show set out as follows:-

Cust No. Name Pattern Comments

SGE1 Kinga NJ42-1 All
SGE1 Kinga NJ59-5 All
SUK4 Jones NJ42-1 Col 3

To make this easier to read/pick i created a crosstab query from this with cust no. and name as row headings and pattern as column headings.

At the moment the field value is set to count (comments) which is ok, however is there a way of showing the text there instead?

Thanks

Change it from Count(Comments) to First(Comments) in the field value part

Perfect. Thank you