• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 34. Using Queries > Appending Table Records Using an Append Query

Appending Table Records Using an Append Query

An append query appends a group of records in one table to another table.

To start an append query:

1.
Create a new query, selecting the table containing the records you want to append to another table.

2.
With the query open in Design view, choose Append Query from the Query Type pull-down menu (Figure 34.32).

Figure 34.32. Choose Append Query from the Query Type pull-down menu.


or

Choose Append Query from the Query menu.

3.
In the Append dialog box, select the table to which the records will be added. You can specify a table in another database (Figure 34.33).

Figure 34.33. Choose the table you want to receive the appended records.


4.
Click OK.

5.
Select the fields to be added, inserting criteria where necessary (Figure 34.34).

Figure 34.34. The query appends records between two dates.


6.
Click the Datasheet View button to view the records that wil be appended.

7.
Click the Design View button to return to Design view.

8.
Run the query.

9.
Access gives you an opportunity to change your mind. Click Yes to continue.

The records will be appended to the second table.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint