Ask Experts Questions for FREE Help !
Ask
    yash123's Avatar
    yash123 Posts: 2, Reputation: 1
    New Member
    		  
    #1

    Jan 14, 2009, 12:47 AM
    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
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #2

    Jan 14, 2009, 06:21 AM

    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.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

How can I get a job with a record? [ 3 Answers ]

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...

DUI on record. [ 3 Answers ]

Is it still possible to sign up for the navy or any other branch if I have a DUI on my record?

I need to record [ 3 Answers ]

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

Deleting cell phone numbers and she hates me again [ 9 Answers ]

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