How do I set the pattern for increasing a number?

[Essar]

The sequence of numbers for a form I use has an increment pattern. For
example, the beginning number is 788531660. It is increased by 11 six times
and on the seventh time by 4. The resulting numbers would be the following:
788531671, 788531682, 788531693, 788531704, 788531715, 788531726, 788531730,
788531741 and so on. These numbers I must use as auto-numbers on my forms.

 

[Jeff Boyce]

Essar

Access Autonumbers do not provide that functionality. You will have to
create your own routine to do so.

Good luck

Jeff Boyce
<Access MVP>

The sequence of numbers for a form I use has an increment pattern. For
example, the beginning number is 788531660. It is increased by 11 six times
and on the seventh time by 4. The resulting numbers would be the following:
788531671, 788531682, 788531693, 788531704, 788531715, 788531726, 788531730,
788531741 and so on. These numbers I must use as auto-numbers on my

forms.