Combining multiple columns into 1.

[Regnab]

I have four columns in one table. I want to add all the records in each
of these columns into 1 column in another table. Any ideas??

[pietlinden]

add how? you mean mathematically or append? How about 4 append
queries? Sounds like these designs are seriously dodgy. You might
benefit from a look at Michael Hernandez's Database Design for Mere
Mortals...

[Regnab]

Hahahah....... indeed, they are exceptionally dodgy. If only work would
give me the time to actually learn how to do this all properly....

[pietlinden]

In that case, if you have only just started, you may well be better off
describing what your database is supposed to do before going further.
Because bad design makes your work later on MUCH more difficult. If
you design your database well, querying etc is easy (well, most of the
time!) If you do it wrong, then querying is well nigh impossible.

So, I hate to put you on the spot, but describe what this thing does...
What "things" are you keeping info about? How are they related? Once
you've nailed that down, what info do you want out of this thing?

Hope this points you in the right direction.