Combinging info from all columns into one column in same table

[BigOrangePapa]

I am new to Access, so please forgive me. here is the situation. I have all of this data that I imported from text into Access. All of the data that I imported are relative to each other and need to be grouped into one column. Is there a query, function, or anything else by which I can do that? My examp,e is this:

I have a table. The table contains 8 columsn with data in each column. I want to take all the data in all 8 columns and make one comprehensive column with all the data in the 8 separate columns. Any help is appreciated.

 

[PHV]

Something like this ?
SELECT field1 & field2 & ... & field8 AS comprehensive FROM theTable

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[BigOrangePapa]

I don't understand what you are telling me to do. Can you be a little more descriptive on what steps I need to take? Thanks.

 

[PHV]

This is a basic idea for the SQL code of a query.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[BigOrangePapa]

Alright, I did that. It took all the data from each column and placed it in to one column, however it did not break each value out into its own row. So I have value a, b, c, d, e, f all combined to look as if they have been concantenated together into a string. What I need to happen is for each value to become its own row, as well.

 

[PHV]

Like this ?
SELECT field1 AS comprehensive FROM theTable
UNION SELECT field2 FROM theTable
...
UNION SELECT field8 FROM theTable

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[BigOrangePapa]

Ok, Buddy. I got that to work. Now, how do I get that to update to and create its own table? Since, when I go into the SQL specific I can not define an option to "Make Table" query. My preference would be for the table that is my source for this to be updated and my end result be that all of the data be in one column with all of the data be itw own cell.

Your last suggestion worked, but I did a Union SQL query? Was this correct? I am not a techie person, but I am being forced to learn this for a deleiverable that I have, so I am somewhat out of my element. I really do appreciate all of your help.

 

[PHV]

Yes, my last post was an union query.
Create a new query based on the saved union one.
You can then use the Make Table query option.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[BigOrangePapa]

I figured that out after I posted again. You have been awesome. Thanks a lot!!!

 

[MichaelRed]

The 'unfortunate' aspect of the thread is that the 'newbie' is getting, taking and using the advice to simply "perform".

"All information in One 'colunm' ... " is atniethical to the concept of a relational data base and more -or less- defeats the point of even having a database at all. If the "list" represetns the only ever used monolithic atom of information, what is the point of a data base at all? much less the relational power of even the desktop Ms. A?





MichaelRed

 

[BigOrangePapa]

Your problem is that you assume too much by your post. Take into consideration that htis was only one source of data and that it had to be multiplied by and appeneded by other sources. Also considering the fact that the amounbt of data was too large to put into Excel. Don't assume things. You make yourslef look pompous and ignorant.