Microsoft® Office Access™ 2007 Plain & Simple

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

1. Open a query in Design view.

2. Click Make Table.

3. Type a name for ...