Transform

[Chris106]

I know this is probably a easy question for you all but I for the life of me can't figure out the SQL in the query. I have a table with one field in it. I want it do the following.

Field1
A
B
C

A B C (column headings)

The table name is HSC. Thank you for your time.

 

[Minty]

Change your query type to Crosstab and have a play...

 

[Chris106]

Thank you for the quick reply Minty. I tried that and it didn't work for me.

 

[Minty]

Have you got some real data and some real examples of what you are expecting.

 

[Chris106]

I imported data from a spread sheet that comes from a program at work. so the table looks like what I have attached. I want the numbers to be the column headings so I can add info under them. Thank you again for your time.

 

[KenHigg]

What are you doing with the data after you get it in the desired format?

 

[Chris106]

Thank you for the reply KenHigg. I attached a excel spread sheet of how I want it to look / work.

 

[KenHigg]

I think I get the gist of what are trying to do. The problem is you are, in a sense, trying to create dynamic field names which is typically bad juju in database world. You could go to the trouble of writing code to create field name on the fly but then you have to map data values to these dynamic columns, etc., etc. I have not used the pivot query feature in access but it sounds like just the ticket...

 

[Chris106]

Thank you very much for the help and suggestion.

 

[KenHigg]

You're welcome - please let us know how you proceed, I like learning new tricks