Creating Queries in Access 2010
- 6/15/2010
Contents
×
- Introducing Query Types
- Creating a Query Using the Query Wizard
- Editing a Query in Design View
- Using Criteria to Focus Query Results
- Introducing Operators
- Using Queries to Calculate Values
- Creating a Parameter Query
- Finding Duplicate Records
- Finding Unmatched Records
- Writing Query Results to a New Table
- Creating an Update Query
- Creating a Crosstab Query
- Finding the Largest and Smallest Values in a Field by Using a Query
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 the new table.
Click OK.
Click Run.
Click Yes to create a new table that contains the selected records.
TIP
You can write the results of your query to a table in another database by selecting the Another Database option in the Make Table dialog box, clicking the Browse button, and using the file navigation dialog box to identify the database to receive the table.