Sample Header Ad - 728x90

How to convert columns into rows in MS Access

0 votes
1 answer
2879 views
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