Share this Page URL

Chapter 9. Extending Your Use of Queries > Running a Make-Table Query - Pg. 323

Extending Your Use of Queries 323 4. 5. 6. You could select a table that's already included in the database in this step, but when you run the make-table query, the table you select will be replaced. Records aren't appended to a table in a make-table query. Any records already in a table you select are replaced. In the Make Table dialog box, click OK. On the toolbar, click the Run button, and then click Yes in the message box indicating that you will paste records into the new table. Close the CountryProducts query, switch to the Database window, and then open the Coun- tryProducts table in Datasheet view, as shown here: