<div>
Right. That's the problem. Access won't let me. I would usually create a Make Table Query by going to the Select Query and using the Make Table Icon. When I do that, it blanks out all of the exisitng Union Query SQL. When I try to manually insert the INTO statement to make it a Make table, I get the &quot;Action Query...NO Row Source&quot; Error message.
</div>


<div>
<div class="content wysiwyg-content">
I created a Union Query (of two separate queries) because I can't ever seem to get the hang of sub-queries. The problem is that I need to make a table from the results of the Union Query and Access says an &quot;Action Query can not be Used as a Record Source&quot;<br />
<br />
Can Somebody tell me how to get around this? Thanks
</div>
</div>


I created a Union Query (of two separate queries) because I can't ever seem to get the hang of sub-queries. The problem is that I need to make a table from the results of the Union Query and Access says an "Action Query can not be Used as a Record Source"

Can Somebody tell me how to get around this? Thanks

Right. That&#39;s the problem. Access won&#39;t let me. I would usually create a Make Table Query by going to the Select Query and using the Make Table Icon. When I do that, it blanks out all of the exisitng Union Query SQL. When I try to manually insert the INTO statement to make it a Make table, I get the &quot;Action Query...NO Row Source&quot; Error message.

How Can I Turn My Union Query into a Make Table Query?

I created a Union Query (of two separate queries) because I can&#39;t ever seem to get the hang of sub-queries. The problem is that I need to make a table from the results of the Union Query and Access says an &quot;Action Query can not be Used as a Record Source&quot;

Can Somebody tell me how to get around this? Thanks

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.