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

Chapter 13. Creating and Updating Jet Ta... > Creating Action Queries to Append Re...

Creating Action Queries to Append Records to a Table

A make-table query creates the new table structure from the structure of the records that underlie the query. Only the fields of the records that appear in the Datasheet view of the query are added to the new table’s structure. If you design and save a tblShipAddresses table before extracting the duplicated data from the Orders table, you can use an append query to add the extracted data to the new table.

To remove and then append records to the tblShipAddresses table, for example, follow these steps:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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