Appending Question

[scott]

I have a table that looks like this

123 456 789 102
324 365 784 987

I want to append all of these columns on top of each other
with a query to a table so it looks like this.

123
456
789
102
324
365
784
987

How would I go about doing this?

Thanks
Scott

 

[John Viescas]

Create a UNION query first:

SELECT MyTable.Column1
FROM MyTable
UNION ALL
SELECT MyTable.Column2
FROM MyTable
UNION ALL ...

Now use that query as input to a Make Table query.

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out" (coming soon)
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)