Full Version: Adding AutoNum to Make Table query
UtterAccess Discussion Forums > Microsoft® Access > Access Queries
matthewcn
Anyone know how to add an Autonumber field to a table created using a make table query?
ScottGem
Add it afterward
Compucare
How would you do that in a program? Is there any commands or functions to add fields after the Make Tabke Query has run?
ScottGem
Use the ALTER TABLE statement.
Compucare
Thanks for your help! That works perfectly!
ScottGem
glad to assist
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.