Show All

Create a table from another table with a query (MDB)

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

   How?

   1. In the Database window, click Queries under Objects, and then click New on the Database window toolbar.
   2. In the New Query dialog box, click Design View, and then click OK.
   3. In the Show Table dialog box, click the tab that lists the tables or queries whose data you want to work with.
   4. Double-click the name of each object you want to add to the query, and then click Close.
   5. Add fields to the Field row in the design grid, and if you want, specify criteria and a sort order.
   6. To view the query's results, click View on the toolbar.
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. Do one of the following:

   Click Current Database.

   Click Another Database, and then either type the path of the database where you want to put the new table or click Browse to locate the database.

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.
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 again.
9. To create the new table, click Run on the toolbar.

Note  The data in the new table you create does not inherit the field properties or the primary key setting from the original table.