Hi Team,
Can you please advise if there is any query that I can run to convert the row to column headers ? I only have 1 row of data and need to convert it to headers to join it with other tables/queries.
Thanks.
Hi Team,
Can you please advise if there is any query that I can run to convert the row to column headers ? I only have 1 row of data and need to convert it to headers to join it with other tables/queries.
Thanks.
One row of data? How many fields? You want the value in each field to become a column header? This does not sound like normalized structure. Don't really understand what you are trying to do. Want to provide sample data and example of desired output?
However try constructing the headers with expression:
SELECT field1 As value1, field2 As value2 FROM table;
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.