 |
|
| Browse | Ask | Answer | Search | Join/Login |
|
|
||||
|
After deleting record ,still the record should contain numbers serially
Helllo
I have a problem in ms access 2007... I want to know how to make database continuous in serial number after deleting a record from it... for example if I have a table as follows Sl no fname lname 1 aaa bbb 2 yyy xxx 3 rrr uuu In the above example if I delete second row ,then table is Sl no fname lname 1 aaa bbb 3 rrr uuu But I want the serial number to be continuous i.e. 1 2 |
||||
|
||||
|
Why would you want to do this? I really see no value of renumbering records after a deletion. I can see making sure there is a sequential numbering system when creating NEW records, but not renumbering. If you need a sequential numbering for reports use a running sum in a query. |
||||
| Question Tools | Search this Question |
Add your answer here.
Check out some similar questions!
Hey is there any one that can tell me how can I get a new job with this old record haunting me? I have a high school diploma as well as 10 years in sales experience but, nobody will give me the opportunity to prove my skills and work ethic. I ask once again how can I get a new job with a old record...
Is it still possible to sign up for the navy or any other branch if I have a DUI on my record?
hi, im Ashley, i love singing and i want a website or program i can download to record my music, and singing, does anybody know anything that i could use to record with? :p
Well last night I was chilling with my ex girl I gave her some stuff and she asked to help her with her phone and took it and put a picture on there but then I went into her contacts and saw the numbers of 2 guys I don't like one her ex and the other a 34+ yeas old enough to be her dad still with...
View more questions Search
|
