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 ...

Get Microsoft® Office Access™ 2007 Plain & Simple now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.