The data that appears after you run a query appears in table form and Access allows you to work with those results like tables. However, query results are not tables. If you want to place the results of a query into a separate table, you can use the make-table query. This query directs Access to save the results of your query to a new table in either the current database or a different database.
Create a New Table with a Query
 |
In Query Design view, create a select query, including any combination of fields, calculated fields, or criteria.
|
 |
Click the Query Type button list arrow on the Query Design toolbar, and then click Make-Table Query.
|
 |
Type the name of the table you want to create, or click the list arrow, and then select a table from the list if you want to replace the existing one.
|
 |
Click the Current Database option if the table is in the currently open database, or click Another Database and type the name of another database (including the path, if necessary).
|
 |
Click OK.
|
 |
Click the Run button on the Query Design toolbar.
|
 |
Click Yes when Access asks if you're sure you want to create the new table.
|
 |
Open the new table to view the records resulting from the query.
|
|
