SQL or something more complicated?

[trevt]

Good day! Thanks in advance for any help!

I'm not so experienced with SQL, but I have been able to fake it in the past with a bunch of Google and good folks like yourselves.

I need to figure out a SQL clause that would turn a table like this:



Into:



To be exported to excel...

If anyone can list the steps for me, would be awesome.

Thanks!

Trev

[ranman256]

there is no query to do this.
however, you can produce it close ,with a crosstab query, .. but without the 1st row (with 2 fields)

If you want to make your version, youd have to export the data to excel, then run a pivot table.
This may produce your results.

[June7]

Why don't you post actual table fieldnames and data?