Autonumber fileds

Resolved · Medium Priority · Version 2003

Mon 27 Apr 2009, 17:07 Delegate Patrick said...

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

Tue 28 Apr 2009, 09:01 Trainer Rajeev said...

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

Tue 5 May 2009: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Combo box for finding records

You can use a combo box in a form to look up a record. If you place the comb box in the Form header, by then selcting they a field type from the drop down loist, you will see the record for it

View all Access hints and tips