Hello! I would like to chart varying salaries against specific Low, middle and high numbers. Any suggestions on how to show this? Example: Salary 1 10000 Salary 2 12000 Salary 3 16000 Low 9000 Mid 15000 High 19000 THANK YOU! Do you want the Low-Mid-High values to be like a benchmark to measure salaries against? You could put horizontal lines across your chart, and use markers for the salary data. Here’ a few ways to get your lines: http://peltiertech.com/Excel/Charts/AddLine.html – Jon ——- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials…
The Sequence Field has no switch to change the interval between numbers. It is always the next integer from the last one unless you are restarting the numbering. So, if you want a sequence of odd (1, 3, 5, 7,…) or even (2, 4, 6, 8, …) numbers, how can you generate it using the SEQ field?
Of course, it’s possible, and not very hard. All you have to do is to learn how to use variables. It sounds a bit tricky at the start, but it’s dead easy. At work I use it to print 100-2000 labels at a time with different names for trophies/medallions etc. You only need to know what XML files are and how to create one.
Do it in Excel. Make a file that calculates your numbers and present the results as strings, if proper number format does not exist. Place the result into InDesign. There you can crop off the extras and add all decorations. You must change the starting day in the original excel spreadsheet. In Indesign you click Relink.
For more great tips, visit Bill’s site, MrExcel.com. Also, if you’re new to the concept of VBA and macros, and you’d like to explore further, check out Get started with VBA in Excel 2010 or Create or delete a macro.
Ok I have a logbook tracking data base. I am trying use a field that has the 8 type of books but each book has its own 4 digit number sequence. I am trying to find a way to give me the next number base on the “prefix”.
Also, I followed the nine steps (five steps by your count) — 1) Insert; 2) Quick Parts; 3) Field; 4) Seq [Name]; 5) Options; 6) Formatting; 7) Add to Field; 8) Field Specific Switches; 9) /n; OK; OK, but I keep getting Error! No sequence specified.
In the example I explained, I was using a list, but did it with un-linked text boxes using “continue from previous number” and “continue numbers across stories.” I’m guessing that there is no way to tell InDesign that even though there are 4 text boxes on the page, that there are two different lists? I’d probably have to just create two threaded stories for that scenario to work.
Under Advanced field properties, you should see the values highlighted below: the SEQ code, “int” as the Sequence Identifier, “* Arabic” for Arabic numerals, and “\n” to increment the numbers. Click OK to finish.
Click the text box with the number in it. Press the “Ctrl” and “C” keys together on the keyboard. Move to the next ticket and press the “Ctrl” and “V” keys to paste in the ticket number. Highlight the number and type directly over it with the next sequential number, such as “2.”
I used multi-level lists for this sort of thing. When defining my list, I type “Interrogatory No.” before the number field in the number format definition, link it to a list style, 2nd level I type “Request for Production No”, link it to another list style. I’ll use “Answer” with no number as another level of the list. Then I modify the linked styles so the paragraphs are formatted how I need. In the styles linked to request for production and interrogatories, I will use the style linked to “Answer” as the style for the following paragraph. In the “answer” style, I’ll use Interrogatory as the style for following paragraph.
For InDesign tips and information regarding industry updates, visit our blog and sign up for our informative newsletters. Want to learn even more? Check out all our best-selling handbooks, apps, and our new e-book: Building Apps with Adobe Experience Manager Mobile, available on Amazon.
However, there is a property we can use to get ourselves out of this problem and that is the AbsolutePosition property of the recordset. We can create a textbox, bind it to expression “=RowNumber()” and then create a function on the module behind the form that references the recordset:
WordTips is your source for cost-effective Microsoft Word training. (Microsoft Word is the most popular word processing software in the world.) This tip (8180) applies to Microsoft Word 2007, 2010, and 2013. You can find a version of this tip for the older menu interface of Word here: Numbering With Sequence Fields.
To ensure each number fills its own text frame, select the whole story (Command/Ctrl-A), open the Keep Options (Command/Ctrl-Option/Alt-K) and choose In Next Frame from the Start Paragraph pop-up menu.
A common question I’ve received has to do with sequential numbering. People often want to use some identifier for their records that involves information about the record and a sequential number. Sometimes these numbers are sequential throughout the table, other times the sequence is specific to other criteria.
Now, what’s the deal with the UniqueKeyVariant parameter for the RowNumber() function? We are not even using it all! True, but if we didn’t, Access will call RowNumber() only once for an entire query and thus we get “1” for the entire dataset. That is a good way to save on CPU processing – why call Now() for each row? In this case, we want to go against this CPU-saving measure and ensure that the RowNumber() is in fact called once per row to generate a new number for that row. Thus, we pass in a parameter — a primary key of a table is a good choice for this purpose. So we get a nice sequential number generated all in the query with VBA function.
Add specific codes to coupons to track customer responses Use different codes for your different marketing messages, advertisements, or promotions. These codes will enable you to keep track of how customers learned about your offer. The more you learn about who is drawn to your business and what attracts customers’ attention, the better you can focus future marketing efforts.
After animating a scene from frame -45 to +45, I looked at the sequence of files in their folder and it goes like 0000, 0001, -001, 0002, -002, etc. Is there a way to get these in a sequence starting from -45 –> 0 –> +45?
If you use numbers, you could generate a CSV-file using Excel. Start by putting the first number in the desired sequence in a cell and then drag this cell in the border downwards. Excel should now make a list of incremented values, you can export to csv.
Note that the list name remains the same for all of these tags. Table titles have a level 4 designation, and Figure titles have a level 5. The numbering style calls out the level 4 numbers (^4) on the Table titles, and the level 5 numbers (^5) for the Figure titles. It’s important to note that for this style, both of these restart after the level 3s (Subhead 2s).
Creating a sequential list of numbers, in Word, sounds like an intimidating task. Sure, you can create a numbered list quickly enough, but that feature works with additional text – you’re numbering something. If you want a list of just numbers, you have to work a bit harder. Word’s SEQ field might come to mind, but that solution is better suited to template-type numbering. In order words, this field works great if you’re numbering documents, labels, and so on. It doesn’t work so well if you just want to create a list of sequential numbers. You can use it that way, but it’ll be more work than it’s worth.
This chapter (web page) takes you through how numbering is supposed to work in Word and the various controls. It is useful, but primarily on SEQ fields and simple numbered lists and also as reference showing the menus, dialogs and controls and going through the concepts for outline numbering. To actually set up outline numbering that works, refer to the Kelly and McGhie articles.
We’re a friendly discussion community for Microsoft Office help and support. All of the individual suite applications are supported here, so please post your question in the relevant section for help. More About Us…
Now I’m having multiple problems even if i see the sequential numbering in the form view under transaction_ID field, it does not “save” those numbers in the transaction_ID in passengertable but it shows up in the form view (passengerform).
Most everything? I, like Larry, saw that a post that states that a major supplier of lasers has broken their ability to handle Corel’s Print Merge. While I find that hard to believe, no one has come back to say it is not true, so as he suggested, be sure your supplier demonstrates that capability.
To enter specific sequential number codes, such as purchase order numbers, you can use the ROW function together with the TEXT function. For example, to start a numbered list by using 000-001, you enter the formula =TEXT(ROW(A1),”000-000″) in the first cell of the range that you want to number, and then drag the fill handle to the end of the range.
do you do your own engraving, or do you sub it out? All the basic engraving software I encountered years ago in an engraving shop did sequential numbering, so if subbing, maybe setting up the file is not needed?
Hi Cathy – I’m not sure what would cause that to be honest. Because (even with these instructions!) it can be quite hard to get Word to do this right, I did build a little web-based service sequential numbering in coreldraw do the same thing. Have you tried that? http://app.raffleticketcreator.com
Generally, when you want to change the formatting of some text, you have to select it with the Type tool. However, there are two caveats to this statement. First, because paragraph formatting (which we’ll discuss later) always applies to an entire paragraph, you don’t have to select every character in the paragraph before applying it.
In the Number box, use the default expression—period (.) and tab space (^t)—or construct a number expression of your own. To enter a number expression, delete the period after the number metacharacter (^#) and do one of the following:
Of course, there are third-party solutions that are available for creating sequentially numbered labels. One that comes highly recommended by several WordTips subscribers is Bates Labels from Payne Consulting (http://www.payneconsulting.com). This free Word template allows you to easily create as many labels as you need for a specific purpose.