Combining four columns in one

[njwcad]

Can you please help

I am running a query that sourced from a number of tables and results in say 10 columns of data. I would like to be able to combine the first 4 columns into 1 (they are all the same format).
For example - first query
Column 1 Column 2 Column 3 Column 4 Other Columns

Second Query
Column 1 Other Columns
Column 2
Column 3
Column 4

Hope this makes sense. If not please let me know and thanks in advance of any help you can give

Rgds

 

[Golom]

Have a look at faq701-3499

[small]No! No! You're not thinking ... you're only being logical.
- Neils Bohr[/small]

 

[njwcad]

Thanks - worked a treat