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.