<div>
There are a few reason you are getting this error the most common is that your query has a autonumber in it and you have a autonumber in the table you are creating or you have two or more tables that have autonumbers. I can help you but I need to see your query and a list of fields in your tables<br />
<br />

</div>


There are a few reason you are getting this error the most common is that your query has a autonumber in it and you have a autonumber in the table you are creating or you have two or more tables that have autonumbers. I can help you but I need to see your query and a list of fields in your tables



<div>
Is there any way I can help you more before you close this question?
</div>


Is there any way I can help you more before you close this question?

<div>
the accepted solution here is a great workaround and worked for me! this was driving me crazy! yeah, just create the table manually then use an append query (rather than create table query) to do the job
</div>


the accepted solution here is a great workaround and worked for me! this was driving me crazy! yeah, just create the table manually then use an append query (rather than create table query) to do the job

<div>
<div class="content wysiwyg-content">
Hi all,<br />
I'm trying to make a new table,<br />
I have the 'select' query that is working fine,<br />
but when I tried to add 'into' (to put result in a new table)<br />
in betwen 'select' and 'from';<br />
it gives the msg:<br />
&quot;Resultant table not allowed to have more than one AutoNumber field.&quot;<br />
<br />
here's the 'select' code that is working fine:<br />
<a href="https://www.experts-exchange.com/questions/21118578/multiple-tables.html" rel="ugc">https://www.experts-exchange.com/questions/21118578/multiple-tables.html</a><br />
<br />
Thanks in advance :D
</div>
</div>


Hi all,
I'm trying to make a new table,
I have the 'select' query that is working fine,
but when I tried to add 'into' (to put result in a new table)
in betwen 'select' and 'from';
it gives the msg:
"Resultant table not allowed to have more than one AutoNumber field."

here's the 'select' code that is working fine:
http://www.experts-exchange.com/Databases/MS_Access/Q_21118578.html

Thanks in advance :D

Resultant table not allowed to have more than one AutoNumber field.

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.