In MSAccess I have a table with column
I want to make this column as rows as shown below using an SQL query preferably using PIVOT TRANSFORM. Any help is appreciated!Code:1 Col1, Col2, Col3, Col4.Code:1 Col1, 2 Col2 3 Col3 4 Col4
Novice
Windows XP 
Access 2000
In MSAccess I have a table with column
I want to make this column as rows as shown below using an SQL query preferably using PIVOT TRANSFORM. Any help is appreciated!Code:1 Col1, Col2, Col3, Col4.Code:1 Col1, 2 Col2 3 Col3 4 Col4
Novice
Windows XP Access 2007
What does the data look like in those columns? Are you wanting to count the records, total them, average them?
Posting Permissions
Reply With Quote