Keith
Access "Autonumbers" are, well, automatic. Your only control is whether
Access attempts to assign them sequentially or randomly. This generally
makes Autonumbers great for arbitrary row IDs for relational purposes. This
also makes them generally unfit for human consumption.
If you need a sequence number that will be seen/altered by humans, or a
"jump by 5" ID, you'll need to roll your own routine to do this.
Now, why?
When I see someone trying to "number by 5's", they frequently are trying to
leave themselves room to intersperse new records between existing records.
In Access, tables hold rows like buckets of data.
If you need to order the output of rows, be sure to include your selection
and sorting criteria as fields in the table, then use a query to do so.
Good luck
Jeff Boyce
<Access MVP>
