Query or script to change column headings?

Question

What would the script be to change the column names to a result of a query?

Here is what I am trying to do...

I have a table with Fields 1-5. Based on the results of a query, the data in Fields 1-5 are what I now want to have as my column headings in a new Table. Is this even possible?

To Clarify - I have Field1, Field2, Field3, Field4 and Field5.

When I run my query the data in my table comes back with A, B, C, D, E.

I now want a table that has A, B, C, D, E as the Field Names for the new Table

What is the easiest way to do this?

Answer 1

Correction --

Use a union query to put the data in separate records, then crosstab query to produce new output fields, and follow with a make table query.

Answer 2

Your statement 'does not work' tells me nothing that I can use to help you.  

What was your results?

Post the SQL of the queries that did not work.

Answer 3

Karl,

Thank you for the quick reply. The suggestion that you have does not work.

~AL~

Answer 4

Use a crosstab query followed by a make table query.