Patrick has attended:
Access Introduction course
Access Intermediate course
Autonumber fileds
I have cereated a database and each record has been assigned an autonumber.
However, a few recirds have been deleted and the autonumbering now starts at 20. How can I re-number the autonumbers so that they start at 1 again?
Regards,
Patrick
RE: Autonumber fileds
Dear Patrick
Thank you for attending Access Courses!! I hope you enjoyed the courses and benefited from them.
Please refer to the following link to reset your Auto number lists.
You will be required to create a make table query. It has got step by step instruction so it should be quite straight forward to follow it.
http://support.microsoft.com/kb/812718
I hope this has answered your query.
If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!
Kindest Regards
Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT
