How to Append Queries in Microsoft Access
Append Query Option when Designing Queries in MS Access 2013
Append Query Option when Designing Queries in MS Access 2007 and 2010
Append Queries are very powerful and lets you combine data from multiple tables and/or queries, specify criteria and put them into fields of an existing table. Think of it as a SELECT query where you can save the results in a table. The field names of the source and target tables do not need to match. In fact, you can create expressions to combine fields, use VBA functions, etc., to insert new values into the table.
Append Queries make it easy to save data at a point in time, use the data for temporary analysis, and display it in forms and reports. Of course, once in the new table, any edits in the new table do not impact the data in the original source. If that’s needed, stick to SELECT queries.
Designing an Append/Insert Query
From the Microsoft Access query designer, you can interactively create a query and specify its type. When you select Append, you are prompted to enter the name of the table that you want to insert records:
Specify the name of the table from the combo box. The table should already exist in your database.
The query designer is similar to how you’d create a SELECT query. You can specify criteria, create expressions, link between multiple tables and queries, etc. The difference is an “Append To” row that specifies which field in the target table each column is inserted into:
Notice in the example above that the Source field is called Memo that is being inserted into the Description field of the target table. Append Queries make it easy to put fields into different field names. It can also be an expression (formula) that’s inserted into a field.
Once the query is saved, you can run it to insert the records into your target table. If you want just this query’s results in that table, empty the table first before running the append query. You can create a Delete Query to empty all the records and run that first.