Problem with a crossed-field queru

[PLA300]

Hi!
I created the queries the uploaded file (not sure Crossed-field is a good translation)


the "numeric" one works correctly, it put the values under the correct column.

I'd like the "text" one works in the same way but I cant set the query in the same way because the "value" field is not a number, how I can do?

(i don't know sql)

best regards!

[June7]

This is PIVOT or CROSSTAB. I think you need to use the FIRST aggregate function which would also work with your numeric query because by including the unique ID field you really aren't doing any summary calcs.