Possible to pull two fields of data into one output column?

[AtLarge]

I have one table and my query finds the records I need and outputs two columns of data. Like this:

1, 2
1, 2
1, 2

I need those two columns (different fields of the same record) to be in one column so I can eventually use the make table and use it for another purpose. Like this:
1
2
1
2
1
2

I've been reviewing joins and yet I cannot make the connection or think of a better way to do it. Any suggestions? TIA.

 

[pbaldy]

Try a UNION query:

SELECT Field1
FROM TableName
UNION ALL
SELECT Field2
FROM TableName

 

[AtLarge]

Aaahhhh, much better now. Thanx PBaldy!

 

[AtLarge]

Rats. Ran into one small problem. Now that I have my working union query I can't convert it to a Make Table Query. When I try to run it I get the error message:

An action query cannot be used as a row source.

Here's my SQL statement.

SELECT DISTINCT ALL_WU_DATA.Component, ALL_WU_DATA.MMPP INTO UP_TO_WM IN 'I:\JUNK\HOLD_FOR_WM.mdb'
FROM ALL_WU_DATA
WHERE (((ALL_WU_DATA.MMPP)="AC" Or (ALL_WU_DATA.MMPP)="LP" Or (ALL_WU_DATA.MMPP)="LL" Or (ALL_WU_DATA.MMPP)="LB") AND ((ALL_WU_DATA.[Top-level]) Is Not Null) AND ((ALL_WU_DATA.ProcType)="F"))
ORDER BY ALL_WU_DATA.MMPP
UNION ALL SELECT DISTINCT ALL_WU_DATA.[BOM-Mtrl#], ALL_WU_DATA.MMPP
FROM ALL_WU_DATA
WHERE (((ALL_WU_DATA.MMPP)="AC" Or (ALL_WU_DATA.MMPP)="LP" Or (ALL_WU_DATA.MMPP)="LL" Or (ALL_WU_DATA.MMPP)="LB") AND ((ALL_WU_DATA.[Top-level]) Is Not Null) AND ((ALL_WU_DATA.ProcType)="F"))
ORDER BY ALL_WU_DATA.MMPP;

Anything I can change to make this work?