Create a new table from the results of a query with a make-table query

Create a new table from the results of a query with a make-table query

  1. Create a query, selecting the tables or queries that contain the records you want to put in the new table.

    How?

  2. In query Design view, click the arrow next to Query Type on the toolbar, and then click Make Table. The Make Table dialog box appears.

  3. In the Table Name box, enter the name of the table you want to create or replace.

  4. Click Current Database to put the new table in the currently open database. Or click Another Database and type the name of the database you want to put the new table in. Type the path if necessary.

  5. Click OK.

  6. Drag from the field list to the query design grid the fields you want in the new table.

  7. In the Criteria cell for the fields that you've dragged to the grid, type the criteria.

    For information on specifying criteria, click .

  8. To preview the new table before you create it, click View on the toolbar. To return to query Design view and make changes or run the query, click View on the toolbar.

  9. To create the new table, click Run on the toolbar.

Notes