Please help me to understand, how to convert columns to rows in MS Access. I have the below table, I would like to convert as the below result table.
`
NoOf_A NoOf_B NoOf_C NoOf_D
200 300 400 500
`
Result Table:
`
Type_OfCValue Total
NoOf_A 200
NoOf_B 300
NoOf_C 400
NoOf_D 500
`
Asked by KCR
(7 rep)
Apr 23, 2020, 11:16 AM
Last activity: Apr 23, 2020, 07:56 PM
Last activity: Apr 23, 2020, 07:56 PM