Thank you for these instructions!! I'm using them to auto number my son's baseball team raffle tickets which we hand numbered last year (UGH!). I followed the instructions exactly but for some reason the numbering is starting at 2 every time. I did deselect the checkbox about the column headers which seems the obvious culprit. Any ideas? I'm using Word on a PC. Thanks!!
Good morning! Directions are clear for sure but when i go to merge the first ticket is one but the second number on the raffle ticket is two. i have four raffle tickets per page the first three are messed up but the forth is correct all the way down to 500. Any ideas? i have tried with a header and without a header. i even made the first number with a formula. it does work with out putting next record but like you said it is four tickets with the same number and that would use a ton of ink. Any help would be greatly appreciated.
Ok I guess it is better for me to explain what I am doing. I am in the process of creating an Access Database that an individual has been using an Excel spreadsheet forever and a day. Well the individual has on occasion doubled up numbers, forgot numbers, etc. So on what I have learned from different Access courses and Google searches I am trying to apply my knowledge.

If you are designing and building a Trident-class submarine, a MIG-27 jet fighter or an international space station, you, most likely, will need millions of parts, so a long part number format would be needed and will make sence. Otherwise, save yourself the trouble of reading all those zeros and make your numbering system practical. Our Documentation Management Procedure shown in Chapter 3 prescribes part numeration with a four-digit part number format that allows for 9,999 parts, which is probably enough for majority of companies. If your operation is small, drop it to three digits – you may always change it later if you need to. One of my customers, who won my “the Best Part Number” Grand Prize, numbered their documents as 201, 202, 203, and so on. Short and sweet!
I am trying to do a similar thing, but I would like to number each reference number sequentially starting at 1 each time when the account number changes.  I am using for manufacturing though.  Each job will have operations open and within the query I want to number each jobs operation with a sequential number starting at one.  When the job changes then the numbering will begin again.  There is a sequence number for each job operation that sorts it, but it is different for each job so that field I believe can only be used to sort the numbering function.
In the Republic of Ireland, junction numbers have existed since the opening of the first section of the M50 motorway in 1990, however due to the short length of Irish motorways until the early 2000s they were normally ignored by the general public. They are beginning to come into popular usage now, and since 2005 have been given greater prominence on road signs. With the development of the inter-urban motorway network under the National Development Plan and Transport 21, the National Roads Authority has adopted a numbering scheme for the inter-urban roads that will see Junction 1 being designated as that road's junction with the M50 in most cases. This has meant renumbering of existing junctions on some motorways, most notably the M7 motorway. Non-motorway dual carriageways forming part of major inter-urban roads also have junction numbers, however only grade-separated interchanges are numbered.
Informally, a sequence has a limit if the elements of the sequence become closer and closer to some value {\displaystyle L} (called the limit of the sequence), and they become and remain arbitrarily close to {\displaystyle L} , meaning that given a real number {\displaystyle d} greater than zero, all but a finite number of the elements of the sequence have a distance from {\displaystyle L} less than {\displaystyle d} .
It’s best to use something other than general copy paper when printing raffle tickets. Heavier weight paper, or even card stock, could be a better choice. Not only does it look more professional, but the tickets will tear off more easily along the perforation. Choose paper colors on the lighter end of the spectrum so that the template design shows up clearly when printed.

I am trying to do a similar thing, but I would like to number each reference number sequentially starting at 1 each time when the account number changes.  I am using for manufacturing though.  Each job will have operations open and within the query I want to number each jobs operation with a sequential number starting at one.  When the job changes then the numbering will begin again.  There is a sequence number for each job operation that sorts it, but it is different for each job so that field I believe can only be used to sort the numbering function. sequential numbering
×