CODEWITHSUNDEEP
sqldatabasems-accessrowstranspose
BobbyJones
BobbyJones

Reputation: 1364

Transposing Specifc Column to Row Headers and Count, then order by Division

I really, really need your help with this,

I'd like to have an SQL query that I could run using MS Access/ADO Jet 4.0 that would take the data from the top table (which is a working example of what is the current data structure in the MDB file) and produce the resulting metrics table in the 2nd table depicted below thus Transposing the [Request Type] Column to Row Headers and Count, then order by Division.

This seems like advanced SQL algebra to me, and goes far beyond my level of SQL knowledge/programming.

enter image description here

Upvotes: 0

Views: 34

Answers (1)

Sergey S.
Sergey S.

Reputation: 6336

You need query like this:

TRANSFORM Count(Table1.[Division]) AS CountOfDivision
SELECT Table1.[Branch], Table1.Division
FROM Table1
GROUP BY Table1.[Branch], Table1.Division
PIVOT Table1.[RequestType];

Upvotes: 0

Related Questions