make two columns into one

[Cameron Sutherland]

If you only need to view the data in one column make a
UNION query. This will combine the data.
Example:

SELECT Table1.Field1
FROM Table1
union
SELECT Table1.Field2
FROM Table1;

Basically you can take two SQL statements and combine them
with the word UNION. Unfortunately there is no graphical
way to display a Union query so you have to do it from SQL
View. Create two queries then paste them together with the
word UNION between them. Also look up your help files
for "UNION Operation"

-Cameron Sutherland