Access AutoNumbers

[Guest]

How do I adjust he increment of an autonumber field. Instead of incrementing
by one, I want to increment by 5.

 

[Jeff Boyce]

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>

 

[Joseph Meehan]

How do I adjust he increment of an autonumber field. Instead of
incrementing by one, I want to increment by 5.

I suggest you may not want to use Autonumber for that use. Autonumbers are
designed to provide unique numbers. It in not designed to provide numbers
in order and for a number of reasons may not do so. As a result using them
in any application where the user sees the numbers is likely to end up with
confusion.

There are other ways of providing the numbers you want depending on the
particual application.