How do I set the pattern for increasing a number?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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>

Essar said:
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
Click to expand...
forms.
 
Back
Top