Why if you deleted couple records and adding a new one, the auto number gives the next number include deleted records number? For example if you deleted number 25 and 26. And add the new one record the auto number gives 27 instead of 25.
And one more question if I start brand new database can I initialize my first auto number with any number for example it will start my employee id = 400 instead of 1?

---

Reply from Richard Rost:

That's just how Autonumbers work. If you insert 1, 2, 3 and then delete 3, the next record is ID 4. Once you even START using an Autonumber (even if you don't save the record) then it's gone. For good. Well... there is a TRICK to get some AN's back if they're at the END of your table, but you don't need to worry about that. You shouldn't CARE what your Autonumbers say. They're ONLY useful for creating relationships between tables. You don't ever need to even see them.