Budget is our income and sometimes this is positive. I need to make this column in a query all negitive values. I am using the IIf function but it is not working. Budget: [budget_amount] IIf ([budget_amount] >=0, [budget_amount]*-1, [budget_amount]) or is there another function I could use? On Mon, 29 Oct 2007 19:18:00 -0700, Tamm Fox wrote: > Budget is our income and sometimes this is positive. I need to make this > column in a query all negitive values. > > I am using the IIf function but it is not working. > > Budget: [budget_amount] IIf ([budget_amount] &g...
I am trying to automatically print sequential numbers on individual cards on 8.5" x 11" business card stock (to create tickets) using MS Publisher and cannot figure out how to get it to do this. Does anyone know the secret? Thanks. Hi Scott (scottmarsh@excite.com), in the newsgroups you posted: || I am trying to automatically print sequential numbers on individual || cards on 8.5" x 11" business card stock (to create tickets) using MS || Publisher and cannot figure out how to get it to do this. Does || anyone know the secret? Thanks. Check out the following tutorial:...

I like where your idea is going, but I cannot figure out how to consecutively number across text frames on one document. So far I have created a csv document in Excel, drew a textbox, imported the csv file into the Data Merge window and dragged it into the text frame. Now, I've got "<<00001>>" in the text frame. When I click "Create Merged Document" I get an error message: "Cannot creat merged document because no placeholders are present..." Now what?


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


Using this script… no. While I use the data merge feature of InDesign often, I avoid the “multiple records” feature, but I typically prepare one record on one page, output the resulting file to PDF and then let the imposing software take care of the page imposition. If page imposition software is something that you don’t have, there is an alternate technique that requires preparing one record on a page, and then using the multipageimporter2.5 script to import them onto a larger sheet. Here is the link to that article: http://colecandoo.com/2011/10/28/theres-more-than-one-way-to-cut-and-stack/

To create a running list—a list that is interrupted by other paragraphs or that spans multiple stories or documents—create a paragraph style and apply the style to paragraphs that you want to be part of the list. For example, to create a running list of the tables in your document, create a paragraph style called Tables, make a defined list part of the style, and then apply the Tables paragraph style to all paragraphs you want in your Table list.
For controlname you need to use the name of the control bound to your Project ID# field. However, the # may be complicating things. Type the Me. and Intellisense should give you a list of controls and methods. Press the P key to go to Ps and scroll until you find the controlname. Selecting the name from the Intellisense list will make sure you are using the correct control. That control needs to have a ControlSource of the Project ID# field. If you do this correctly, then pressing the button should populate the control with the next number. It will also save the record.

@Andy: I’m sorry that I sounded dismissive. That wasn’t my intent. Rather, I was just admitting that I had no idea why someone using CS3 would not see the dialog boxes as they are shown above. If you’re using CS2, they would be significantly different. But the second part of the tip (where I show the numbering dialog boxes) relies on CS3 or later. If you are using CS3 or CS4 and you don’t see that dialog box, feel free to email me at david [at] indesignsecrets [dot] com and send me a screen shot of what you are seeing.

A sequence can be thought of as a list of elements with a particular order. Sequences are useful in a number of mathematical disciplines for studying functions, spaces, and other mathematical structures using the convergence properties of sequences. In particular, sequences are the basis for series, which are important in differential equations and analysis. Sequences are also of interest in their own right and can be studied as patterns or puzzles, such as in the study of prime numbers.
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.
Drag the number, which Publisher defaults to “1,” into place on the ticket. To change the sequence, such as to start with “100” instead of “1,” click the “Page Number” button again and choose “Format Page Numbers.” Click the “Start this section with” radio button and type the new number into the field. Click the “OK” button to have Publisher update the ticket number.
I have a similar question about numbering – but a bit more complicated. U want to convert the caption number sequences from a single number sequence to reflect the heading that the table/figure is sitting under. For example, if it’s sitting under heading 6.2, the first table or figure would be Table/Figure 6.2 a, then 6.2 b and so on, until after the next heading, where they would start again – 6.3 a and so on. How do I do that?!!
I have a similar question about numbering – but a bit more complicated. U want to convert the caption number sequences from a single number sequence to reflect the heading that the table/figure is sitting under. For example, if it’s sitting under heading 6.2, the first table or figure would be Table/Figure 6.2 a, then 6.2 b and so on, until after the next heading, where they would start again – 6.3 a and so on. How do I do that?!!
WordTips is your source for cost-effective Microsoft Word training. (Microsoft Word is the most popular word processing software in the world.) This tip (92) applies to Microsoft Word 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Word (Word 2007 and later) here: Sequentially Numbering Elements in Your Document.
×