If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I set the pattern for increasing a number?
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. |
#2
|
|||
|
|||
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" wrote in message ... 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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Combo Box & Text Box | AccessRookie | Using Forms | 3 | April 6th, 2005 11:33 PM |
help needed | jkendrick75 | Running & Setting Up Queries | 19 | March 17th, 2005 02:37 PM |
Number of objects | thomak | General Discussion | 3 | February 17th, 2005 11:58 AM |
Maximum number of pages in a word document | Travis75 | Formatting Long Documents | 5 | January 27th, 2005 05:03 AM |
Setting A Number Equal to Another Number | slag018 | General Discussion | 1 | October 19th, 2004 04:16 AM |