mistux Site Admin
Joined: 25 Jun 2004 Posts: 1042 Location: South Bend, Indiana USA
|
Posted: Mon Sep 22, 2014 3:51 pm Post subject: Resultant Table not allowed to have more than one AutoNumbe |
|
|
Q:
I have a Make Table Query that has several fields from different Tables. I have two fields that I want in this new table of this that are AutoNumber Fields.
Whenver I try to execute this Make Table Query, I get an error saying "Resultant Table not allowed to have more than one AutoNumber field."
A:
Yes it is possible to do. Here is how I do it.
In the query used a calculated field with the Clng() to convert the data type.
Example:
MyFieldName: Clng([MyAutoNumberField])
or the SQL
Clng([MyAutoNumberField]) as MyFieldName
You may have to reference the actual table name in it like:
MyFieldName: Clng([tblParts.][MyAutoNumberField]) |
|