Hi All, I am working on a YTD Sales report. I would like to know if I can create a cell in a query that will be a squential number. Starting with 1 on up. If so how would I do this? Report would look something like: Num Customer YTD Sales 1 Bobs Sales 495,000 2 Denny's 395,000 3 Biffs Supply 390,000 4.... -- Matt Campbell mattc (at) saunatec [dot] com Message posted via http://www.accessmonster.com You can use a text box in the report: Control Source: =1 Running Sum: Over All -- Duane Hookom Microsoft Access MVP "mattc66 via AccessMo...
Scott, you’ll need to be more specific to help me. When you say “put this code behind a save button” what exactly does that mean – where do I type the code you provided? Yes, I do have a Save Button, which saves the record and closes the form (but currently has no way to save the next sequential Project ID). I want show this next Project ID (number on the entry form) and have that new number flow to the table along with the other data on the form.
To design a certificate from scratch, you can either start with a completely blank publication or adapt an existing publication. Small-sized publication types, such as business cards, postcards, and labels can be adapted to serve as coupons. Flyers or brochures can be adapted for use as gift certificates. For more information, see Create a publication in Publisher. sequential numbering in word
Here is my problem. i have a series of 3 digit numbers that need to be cinverted to a series of 4 digit numbers using this following 722 needs to read as 5622 and in the next collum SV-7822 in the collum's to the right. what type of formula is this and how can i do it? The above is an example, i have a whole range of 3 digit numbers that need the exact. rules applied to all numbers. which is why i need a formula to do it. Help someone please!!!! I'm not completely clear on what your looking for but if 722 was in A1 in B1: = A1 + 4900 in B2: = ="SV-" & A1 + 7100...

* The solution assumes that there is only one stack to cut, but really there could be dozens of stacks. Take a run of the numbers 1-10000 for example. Let’s say you get 4-up on a sheet and the biggest stack that will fit in the guillotine is 500 sheets. A true cut and stack solution will print on the first stack 1-500, 501-1000, 1001-1500, 1501-2000. Ideal because the numbers can be guillotined and placed back onto a pallet for its next process. It also means I can provide these numbers first to the client and then they can wait for the other numbers (in case they had run out of stock and were in a hurry for replenishment stock). The solution doesn’t do that – instead, the first 500 stack will have the numbers 1-500, 2501-3000, 5001-5500, 7501-8000. That means not only is placement back onto the pallet confusing, but the customer has to wait for the artwork to be completely printed before even getting the first half of numbers. True, I could run the script several times to get the appropriate stacks, but why should I if the script did what I wanted? Especially if there are hundreds of stacks to print?


I am printing many pages of tickets. Each page has 5 tickets and I would like to sequentially put a number on each ticket. I have tried to use the auto page numbering feature but that is putting the same number on each of the 5 tickets and then increments for the next page -- not what I need. Also, can the numbering not suppress the leading zeroes? Thanks....

One other thought. It may not hurt to make option 1 a logical expresssion where it will update the number IF a number other than 0 already exists for it. This will prevent it from giving a new number if you go back, edit it and save it. I accomplished this by adding the following (roughly): If PONo=0 Then My.PONo…. (Expression and save command) Else (Save Command)
Apple has a formalized version number structure based around the NumVersion struct, which specifies a one- or two-digit major version, a one-digit minor version, a one-digit “bug” (i.e. revision) version, a stage indicator (drawn from the set development/prealpha, alpha, beta and final/release), and a one-byte (i.e. having values in the range 0–255) pre-release version, which is only used at stages prior to final. In writing these version numbers as strings, the convention is to omit any parts after the minor version whose value are zero (with “final” being considered the zero stage), thus writing 1.0.2 (rather than 1.0.2b12), 1.0.2 (rather than 1.0.2f0), and 1.1 (rather than 1.1.0f0).
Sequential exit numbering usually begins with exit 1 at the beginning of the road; each subsequent exit is given the next number. Letter suffixes are commonly used when new exits are added. For example, on the New York State Thruway, an exit was added between 21 and 22, and was given the number 21A. Subsequently, a new exit was added between 21 and 21A, leading to the sequence 21 - 21B - 21A - 22. In Florida, some new exits got the suffix C, so that if it had or acquired separate exits for the two directions, they would be 15CA and 15CB rather than 15AB. There are also occurrences of this happening on the New Jersey Turnpike; the original interchanges opened in 1951, with newer exits as recently as 1982. On the Baltimore Beltway, there is an exit 12B-C (MD 372), as well as 12A (US 1). There is also an exit 8A (I-895) and an exit 8 (MD 168).
Bottom Line – So, is there: (1) any way to “save” “Auto Text” entries (or similar) so that several people in the office (i.e. attorney, paralegal, secretary, etc.) can “share” and have access to the same set, and thus work better as a “team”?; and (2) if/when a set of “Auto Text” entries is so saved and created, is there any way to keep it “alive” and “safe” so it “survives” the (inevitable) series of computer updates, fixes, server crashes, etc., that will happen over time in a law office (and even several times during the life a litigation case that may last two years or more in an office)?.
Can anyone tell me what the maximum no. of worksheets is in Excel? Ton From Help...Limited by available memory (default is 3) -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS "Ton" wrote in message news:EB5EE739-9250-4D83-AA7C-EE82C02C0AA3@microsoft.com... > Can anyone tell me what the maximum no. of worksheets is in Excel? The maximum number only depends on the amount of memory available. -- Best Regards Leo Heuser Followup to newsgroup only please. "Ton"
CK Note: Word 2007 - 2013 interface has an different automatic numbering scheme which I have been told is much less subject to corruption. Microsoft Word 2010 Bible by Herb Tyson, MVP. However numbering is still very imperfect in these later versions. I still recommend following Shauna Kelly's step-by-step instructions (see above) if setting up numbering in a template or in a document likely to be heavily edited. If you start without doing this and end up with "spaghetti numbering," fixing it will be a very large chore!
Select the Text Tool (T) and start dragging a text box that will wrap around the whole ticket including the crop marks. This is very important since the Data Merge will automatically calculate the duplication. Then open up the Text Frame Option (Command + B) and set the Inset spacing to 1p4 for the top and 1p8 for the left. Of course, you can place the text for the numbers anywhere you like. I set the numbers to a small text.
An InDesign document can only have one chapter, and these chapters are typically combined in an InDesign book. To insert a chapter number, create a text frame where you want the chapter number to appear on either a document or master page. Click on the "Type" menu, then "Text Variables," "Insert Text Variable" and then "Chapter Number." Update the chapter number if necessary to keep your chapter numbers consecutive by clicking on "Numbering & Section Options" in the Layout menu.
Hello, I'm looking for a way to quickly find what numbers are missing in column B. I can sort them ascending, but how do I find if there are missing numbers? 1 2 3 5 6 7 9 I need to know 4 and 8 are missing. Thank you. One way: select B2:Bx. Choose Format/Conditional Formatting... CF1: Formula is =(B2-B1)>1 Format1: / or, without sorting, select column B (with B1 active): CF1: Formula is =AND(B1>MIN(B:B),COUNTIF(B:B,B1-1)=0) Both CF's will activate if there are missing numbers before them. In article <28706E9E-2624...
Joshua, I described this problem in my post #5 — the footnote settings are doc-global. I know no present solution to your problem — which is why we still need Adobe to code a counter! And we also need to be able to set up footnotes which are frame-wide, not just column-wide. And, natch, we need headings which are frame-wide, spanning multiple columns — so the ID engineers can’t retire quite yet. :-)
LION has an economy line, standard-duty numbering machines in both the 5 wheel & the 6 wheel model. As with the heavy-duty line, these automatic numbering machines are also made from one-piece hardened die-cast metal frame and wheels to assure trouble free operation. This self inking numbering machine is ideal for sequential numbering operations to use as a date and number stamp, serial number stamp, inspection stamp and etc. Best choice for the budget conscious users looking for standard quality, durability and low cost.
Thank you for your reply.  It reassured me that I was on the right path. From having read other Help texts, I guessed that I would have to use good ole mail-merge and set up a numbers list in Excel. Luckily my knowledge of Excel was good enough to know about the drag&drop for sequential immediate numbering. When it came to the crunch, it was this particular type of mail merge which gave me a bit of initial difficulty. Despite my having used it happily and often in Word, for labels in Publisher, it was - not surprisingly - different in certain respects; principally the crucial point of the Print stage, which necessitated finding the option Publications & Paper Settings, and selecting 2 specific parameters, namely (1) Multiple pages per sheet,  (2) Single-sided printing (my default double printing had appeared). Once I'd sussed this, it was plain sailing.  Thanks again.
I have a table named Artifact Catalog in which there is a field Collection Point ID and a field Artifact ID. On the form I have created the user will input the Collection Point ID, for example: 2-1050. I need to find a way to have this Collection Point ID automatically generate a corresponding Artifact ID, i.e when you click the save button the first record under Artifact ID becomes: 2-1050.1 and the second becomes 2-1050.2 and so on.
If you want to use a bullet found in a specific font (such as the pointing hand from Dingbats), be sure to set the bullet to remember that font. If you use a basic bullet character, it’s probably best not to remember the font, because most fonts have their own version of that bullet character. Depending on whether you select the Remember Font With Bullet option, a bullet you add can reference either a Unicode value and a specific font family and style, or just a Unicode value.
Automata or finite state machines can typically be thought of as directed graphs, with edges labeled using some specific alphabet, Σ. Most familiar types of automata transition from state to state by reading input letters from Σ, following edges with matching labels; the ordered input for such an automaton forms a sequence called a word (or input word). The sequence of states encountered by the automaton when processing a word is called a run. A nondeterministic automaton may have unlabeled or duplicate out-edges for any state, giving more than one successor for some input letter. This is typically thought of as producing multiple possible runs for a given word, each being a sequence of single states, rather than producing a single run that is a sequence of sets of states; however, 'run' is occasionally used to mean the latter.
If you need to apply numbering within a paragraph rather than to the entire paragraph, you use Word's ListNum feature. Using the ListNum feature will allow you to take advantage of the numbering system you're currently using in your document (it will use the one you implemented most recently if you're not currently using a numbering system). The ListNum Field is available in Word 97 and later and interacts with multi-level list numbering (which should be linked to styles as set forth here). Here is a brief explanation of differences between the ListNum field and the Seq field.
Word includes a special sequencing field that you can use to do all sorts of numbering. You can even use the SEQ field to help create broken numbered lists. (A broken numbered list is one in which the flow of the list is interrupted by paragraphs of a different format.) This approach to creating numbered lists is particularly helpful and much less prone to the problems inherent in Word's built-in list numbering. For the purposes of this tip, the format of the sequence field is as follows:
It sure is possible! Numbering and Section options are available in the Pages Panel menu. These options allow you to define what page starts a section and how it should be numbered. Insert a Current Page Number marker (Type>Insert Special Character>Markers>Current Page Number) in a text frame on a page or master page (recommended), select the first page of your section, open the Numbering and Section Options dialog, and enter 200 in the Start Page Numbering at: field. Hope this helps!
Your raffle might be subject to gaming commission or tax laws. Check with your municipality, state or province, and federal governments to make sure your raffle is legal. These government departments aren’t just enforcers. They are often great resources on how to run a successful fund raising raffle. Raffles are fun! Getting in trouble with the law or tax man is not.
when I assign a heading level to a figure, all the other figures at different heading levels change to the level I assigned the new figure. ie, I have a figure under chapter heading level 3, then I have a figure in the next section under chapter heading level 1. When I select chapter heading numbering for header 1, all the other figures in my document go to that level instead of maintaining their specific level…help?
Is there a way to do this: I have a form called "List of Proposals Written" that is listed by th Proposal number. Is there a way to display on another excel spreadsheet, the mos current Proposal number? I know Access you use something like Dmax(ProposalID)+1 What should I do in Excel:confused: Any help would be greatly appreciated! Michae -- Message posted from http://www.ExcelForum.com "daniels012 >" < wrote > I have a form called "List of Proposals Written" that is listed by the > Propos...
Does anybody have a way of formatting the phone numbers in Outlook 2003 so that they appear as xxx yyy zzzz that is no dashes, no parentheses? If I am going to synch to my PDA I want the numbers as short as possible and, to me, as readable as possible. Steve No. Masking of phone numbers is hard coded and based on your default dialing location. -- Russ Valentine [MVP-Outlook] "Steve E." wrote in message news:2dd601c48eb8$3ff4a1e0$a601280a@phx.gbl... > Does anybody have a way of formatting the phone numbers in > Outlook 2003 so that they appear as x...

Hello, I'm looking for a way to quickly find what numbers are missing in column B. I can sort them ascending, but how do I find if there are missing numbers? 1 2 3 5 6 7 9 I need to know 4 and 8 are missing. Thank you. One way: select B2:Bx. Choose Format/Conditional Formatting... CF1: Formula is =(B2-B1)>1 Format1: / or, without sorting, select column B (with B1 active): CF1: Formula is =AND(B1>MIN(B:B),COUNTIF(B:B,B1-1)=0) Both CF's will activate if there are missing numbers before them. In article <28706E9E-2624...
Can anyone tell me what the maximum no. of worksheets is in Excel? Ton From Help...Limited by available memory (default is 3) -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS "Ton" wrote in message news:EB5EE739-9250-4D83-AA7C-EE82C02C0AA3@microsoft.com... > Can anyone tell me what the maximum no. of worksheets is in Excel? The maximum number only depends on the amount of memory available. -- Best Regards Leo Heuser Followup to newsgroup only please. "Ton"
Warning  Making even minor changes to an outline numbering scheme won't necessarily change the initial position you've selected in the gallery, but rather may create a new gallery position, overwriting an existing one. Because of this problem, attaching numbering to styles is strongly recommended. This is covered in greater detail later in this chapter and in the chapter on Styles.

Both the United Kingdom and the Republic of Ireland use sequential numbering systems, with the junction number indicated by a white number in a black square in the corner of signs. In the United Kingdom they are frequently referenced in the media as the number with "J" on front of it, with for example Junction 1 being referred to as "J1". If a junction is newly constructed to between two existing junctions, it is normally allocated the number of the lower of the two junctions, with the letter "A" attached (and so on). For example, a new junction opened between junctions 3 and 4 would become Junction 3A.
×