• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 34. Using Queries > Creating a Table of Query Results Using a Make-Tabl...

Creating a Table of Query Results Using a Make-Table Query

A make-table query creates a table containing the query results.

To start a make-table query:

1.
Create a new query, selecting the fields from one or more tables, and adding criteria as required.

or

Open an existing query.

2.
With the query open in Design view, choose Make-Table Query from the Query Type pull-down menu (Figure 34.35).

Figure 34.35. Choose Make-Table Query from the Query Type pull-down menu.


or

Choose Make-Table Query from the Query menu.

3.
Type a name for the new table in the Make Table dialog box (Figure 34.36).

Figure 34.36. Type a name for the new table in the Make Table dialog box.


4.
Click OK.

5.
Click the Datasheet View button to view the records that will be included in the new table.

6.
Click the Design View button to return to Design view.

7.
Run the query.

8.
Access gives you an opportunity to change your mind. Click Yes to continue. The new table is created (Figure 34.37).

Figure 34.37. The new table appears in the Tables list.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint