<div>
Couldn't get much simpler thank that! My thanks Derek
</div>


Couldn't get much simpler thank that! My thanks Derek

<div>
<div class="content wysiwyg-content">
How do I get the results from a UNION ALL query into a new table? <br />
<br />
Tried &nbsp;&quot;INTO &quot;TableName&quot;&quot;, works with regular query but not with UNION ALL
</div>
</div>


How do I get the results from a UNION ALL query into a new table? 

Tried  "INTO "TableName"", works with regular query but not with UNION ALL

UNION ALL

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.