Manufacturing Information Solutions Forum Index Manufacturing Information Solutions
Your Place for Support and Discussions
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Resultant Table not allowed to have more than one AutoNumbe

 
Post new topic   Reply to topic    Manufacturing Information Solutions Forum Index -> Microsoft Access
View previous topic :: View next topic  
Author Message
mistux
Site Admin


Joined: 25 Jun 2004
Posts: 1042
Location: South Bend, Indiana USA

PostPosted: Mon Sep 22, 2014 3:51 pm    Post subject: Resultant Table not allowed to have more than one AutoNumbe Reply with quote

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])
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic   Reply to topic    Manufacturing Information Solutions Forum Index -> Microsoft Access All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group