Joined: 25 Jun 2004
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
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."
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.
or the SQL
Clng([MyAutoNumberField]) as MyFieldName
You may have to reference the actual table name in it like: