How to Create an Append Action Query in Microsoft Access
With an Append action query, you can add a group of records from one or several tables to the end of one or more tables. You might do this if you acquire a new database of information that is pertinent to one or more of your tables. Appending the information will save you the trouble of re-typing. These instructions apply to MS Access 97.
Things You'll Need
- Microsoft Access
Open the Database window (F11). Click the Query tab.
Click New, then click Design View.
From the Query menu, select Append. A dialog box appears.
Use the Table Name box to identify the name of the table that is to receive the records.
If the table is in the current database, click Current Database. Otherwise, click Another Database and enter the name and path of the database containing the table.
Drag the fields that you want to use for setting query criteria to the design grid.
If necessary, enter the names of the fields in the table that you are adding the records to.
Use the Criteria cell to enter the criteria on which additions will be made (all values equal to "Memphis" for example).
Switch to Datasheet view to preview the changes, then return to Design view.
Click Run when you are satisfied.