UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Adding AutoNum to Make Table query    
 
   
matthewcn
post Feb 24 2006, 01:04 PM
Post #1

UtterAccess Member
Posts: 42
Anyone know how to add an Autonumber field to a table created using a make table query?
Go to the top of the page
 
+
ScottGem
post Feb 24 2006, 01:37 PM
Post #2

UtterAccess VIP / UA Clown
Posts: 25,041
From: LI, NY
Add it afterward
Go to the top of the page
 
+
Compucare
post Feb 28 2006, 09:25 AM
Post #3

New Member
Posts: 10
How would you do that in a program? Is there any commands or functions to add fields after the Make Tabke Query has run?
Go to the top of the page
 
+
ScottGem
post Feb 28 2006, 11:21 AM
Post #4

UtterAccess VIP / UA Clown
Posts: 25,041
From: LI, NY
Use the ALTER TABLE statement.
Go to the top of the page
 
+
Compucare
post Feb 28 2006, 01:32 PM
Post #5

New Member
Posts: 10
Thanks for your help! That works perfectly!
Go to the top of the page
 
+
ScottGem
post Feb 28 2006, 02:31 PM
Post #6

UtterAccess VIP / UA Clown
Posts: 25,041
From: LI, NY
glad to assist
Go to the top of the page
 
+
« Next Oldest · Access Queries · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 21st May 2013 - 12:34 AM