Two columns stacked into one on different table

[Cazca]

Hi folks.

I'm using MS Access 2010 with a frontend/backend type database.

I'm attempting to take two columns (Name1, Name2) from one table and combine (stack) them into another.

Original:


Name1 Name2
Smith Lawson
Doel Carl

Desired Result:
Name
Smith
Doel
Lawson
Carl


I can run a query to union the two columns in Table1, but how do I get them from the query to Table2?

Any help is greatly appreciated!

[ranman256]

2 append queries,
insert NAME1 into table
insert NAME2 into table

[Cazca]

The goal is once names are deleted from the Original table (where they are seperated into 2 columns), that it deletes from the Combined Table. Would you have to run a query each time to do this, or could you set the query to run when the table opens?

Thanks!

[June7]

How are you opening table? Why are you opening table? Users should not work directly with tables and queries, only forms and reports.

Why would you delete from combined table when you just inserted them into table? Action SQL statements can be run from code.