Avatar of belinda_sg
belinda_sg
 asked on

how can i add one field to my table?

I am using ADO to manipulate my table. i have an input table, then i will output several different tables, for the output table, how can i add an auto-increased ID field into my table? THANK YOU VERY MUCH FOR YOUR SUGGESTION :)
Programming

Avatar of undefined
Last Comment
FaithRaven

8/22/2022 - Mon
bistrica

in table design set property of column to autonumber
dev_tek

Its simple just make that column as autonumber and when u insert record use UPDATE query with out inserting any value for that column.
twalgrave

Please specify further your requirements.
1) What database
2) Are you using ADO to actually create the table, or to return the data from an already-defined table
3) What are the restrictions on the auto-increased ID field (is it OK to have gaps in the numbers?)
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
belinda_sg

ASKER
i use microsoft access to sort my database.
in fact, i am not going to create a table, i am using SQL to select certain records to my new table. so in one form, i use Microsoft Hierarchical FlexGrid Control to show one table, in the new form, i also use the same format, but i wanna add a new field named "S/N" so that i can know that how many records i have for the new table. thank you for you all's help...
ASKER CERTIFIED SOLUTION
twalgrave

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
FaithRaven

No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
Accept twalgrave's comment
Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

FaithRaven
EE Cleanup Volunteer