Auto numbering

Hi again Abigail

Autonumber values will go out of sequence if newly added records are deleteted from the table.

Here's a way to adjust the next Autonumber value so it follows on from the previous number in a table (for example a RoomID in a table called Rooms).

1. First create a new table with 1 field with the same name as the Autonumber field. Change the data type to Number.

For example a table called Tablre1 with field RoomID with no primary key.

2. View Table1 and type the next RoomID number that you want to appear in the Rooms table. Then close Table1.

3. Now create an Append query that appends Table1 to the main table (Rooms). Create, Query Design, Select Table1 then press the Append (+!) from the Design ribbon.

Add RoomID from Table1 and append to Rooms.

Press the Run button (!)

4. Close the query.

The rooms table should now have the next RoomID number in sequence.

Hope that helps Abigail. Best to do this when you are ready to enter a new Room record.

Good luck with developing your database.

Regards
Doug Dunn
Best STL