How to Create an Append Action Query in Microsoft Access
- 1). Open the Database window (F11). Click the Query tab.
- 2). Click New, then click Design View.
- 3). From the Query menu, select Append. A dialog box appears.
- 4). Use the Table Name box to identify the name of the table that is to receive the records.
- 5). 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.
- 6). Click OK.
- 7). Drag the fields that you want to use for setting query criteria to the design grid.
- 8). If necessary, enter the names of the fields in the table that you are adding the records to.
- 9). Use the Criteria cell to enter the criteria on which additions will be made (all values equal to "Memphis" for example).
- 10
Switch to Datasheet view to preview the changes, then return to Design view. - 11
Click Run when you are satisfied.
Source...