I have a need to "Transpose" (Excel Term with which I am familiar) the results of a summing query.
The query sums multiple columns, so it is essentially one row of numbers and a row of headers
I need that to be one column of headers and one column of numbers (It's for Minitab, very picky about it's data format)
Ideally, the two columns would be sorted in descending order by the numbers column.
Is there a way to do that in an Access Query?
Start Free Trial
