Merging Table Data 1

[Hanss]

I would appreciate if someone could point me in the right direction:

This is the data that I have in table1:

Field1 Field2 Field3
10 20 30
40 50 60

I would like a query or vba that merges the data into this:

Field1
10
20
30
40
50
60

Does anyone have any idea if this is possible with an access query?

hanss

 

[PHV]

What about this ?

SELECT Field1 FROM table1
UNION SELECT Field2 FROM table1
UNION SELECT Field3 FROM table1

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Hanss]

Thank you VERY much for pointing me in the right direction!

hanss