Article ID: 208819 - View products that this article applies to.
This article was previously published under Q208819
Moderate: Requires basic macro, coding, and interoperability skills.
This article applies only to a Microsoft Access database (.mdb).
Microsoft Access SQL does not allow you to use the INTO clause (a clause needed to create a make-table query) within a union query. Therefore, you cannot directly create a make-table query; you must first create a union query, and then use the results of that query in the make-table query. This article demonstrates how to do this.
NOTE: You can see a demonstration of the technique that is used in this article in the sample file Qrysmp00.exe. For information about how to obtain this sample file, please see the following article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/207626/EN-US/ )ACC2000: Access 2000 Sample Queries Available in Download Center
To create a table from a union query, you must first define the union query, and then create a make-table query based on the union query results. To do so, follow these steps:
CAUTION: If you follow the steps in this example, you modify the sample database Northwind.mdb. You may want to back up the Northwind.mdb file and follow these steps on a copy of the database.
For more information about union queries, click Microsoft Access Help on the Help menu, type what is an sql query and when would you use one in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
For more information about make-table queries, click Microsoft Access Help on the Help menu, type create a new table from the results of a query with a make-table query in the Office Assistant or the Answer Wizard, and then click Search to view the topic.