Writing Query Results to a New Table
When you run a query, Access writes the records the query finds into a dynaset, or dynamic record set. While Access remembers the results of queries you run, the results aren’t actually written to a table, limiting what you can do with the data. You can, however, modify a select query so the results are written to a new table.
Create a Make-Table Query
Open a query in Design view.
Click Make Table.
Type a name for ...