Note this works only because we create a brand new table, add an autonumber column to it as well any other columns we need then insert records into it. It’ll be contiguous – as long we don’t delete any records from the table. Unfortunately, creating a brand new table every time we run this will result in bloat of the Access file – if you can do it in a separate Access file, all the better so that you can compact it when you need to.
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 need a way for the priority level to automatically adjust when I add or change an item with a new priority level. I might have 6 tasks, each will have a different priority. If I add one and set it to 1, the others need to increment + by one digit. Adding one to the above the highest would see no change in the others. Adding one in the middle would spread the rest apart (e.g. I have a 3, I put a new record and put it at 3, the old 3 becomes 4, and so on (everything below it would increment one digit).


There are a couple of ways you can set up Word 2007/2010 to use SEQ fields for numbering — you can set them up as AutoCorrect entries or as Quick Parts. Both ways work; the method you choose is up to you. This long article describes how to create the SEQ fields and the numbering style in your Normal.dotm template; how to save the SEQ fields as AutoCorrect entries in Word 2007/2010 (and how to use them); and how to save (and use) them as Quick Parts. The most consuming part of this process is settings up the fields and the style; once they’re set up, using them is super easy.
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.
You can control whether your next paragraph number continues the current sequence or starts again at 1 within that same right-click menu. If one of your numbers gets out of sequence, simply right-click and choose Continue Numbering. If you want to force the number back to the beginning (say, you’re switching from interrogatories to requests for production), choose Set Numbering Value (which will also give you the option of continuing the previous list).
InDesign allows you to add a page number marker to a master page within the document. The master page functions as a template for every page it's applied to, so the consecutive page numbers appear on every page. InDesign updates the page number automatically as you insert, delete and move pages. To add a page number marker to a master page, create a text box on the master page by going to the Type menu and choosing "Insert Special Character," "Markers" and then "Current Page Number."

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!

Author, trainer, and learning and development expert David Rivers has over 20 years experience helping government, hi-tech, and healthcare businesses increase their efficiency and productivity by integrating technology tools. With deep experience in Microsoft Office, elearning tools, and assorted productivity tools such as FrameMaker and RoboHelp, David is passionate about helping people improve their workflows to recover time in their schedules. His clients include Microsoft, Corel Corporation, Halogen Software, and the City of Ottawa. David is also a published book author on topics ranging from Photoshop to Acrobat and the Microsoft Digital Image Suite.
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.
Other notations can be useful for sequences whose pattern cannot be easily guessed, or for sequences that do not have a pattern such as the digits of π. One such notation is to write down a general formula for computing the nth term as a function of n, enclose it in parentheses, and include a subscript indicating the range of values that n can take. For example, in this notation the sequence of even numbers could be written as {\displaystyle (2n)_{n\in \mathbb {N} }} . The sequence of squares could be written as {\displaystyle (n^{2})_{n\in \mathbb {N} }} . The variable n is called an index, and the set of values that it can take is called the index set.

GREAT tip with lots of uses! Thank you. This will save me hours of work on some tickets I’m designing. However, I also need to set up table tents that have numbers on them. They’re 2-up, and are folded, so each number needs to appear twice on the same page. In short, I want a page with 1/1 and 2/2, and I’m getting 1/2 and 3/4. Am I missing an obvious fix? Thank you.
Awhile back, there was an add-on for excel that had a lot more tools. It showed on the toolbar. Somehow I lost it and I would like to get it back. It had a lot of tools like for changing case and fill ins. Any help wouyld be great. Maybe ASAP Utilities. Try a 'net search for this add-in. Gord Dibben MS Excel MVP On Sun, 22 Mar 2009 20:22:43 -0400, "kmkx70a" wrote: >Awhile back, there was an add-on for excel that had a lot more tools. It >showed on the toolbar. Somehow I lost it and I would like to get it back. It >had a lot of t...
Hi, As a new user to excel I am thinking of setting up a data base of my music. The total number of tracks is in excess of 70,000. I have seen a simple solution using excel which would be ok but I'm not sure if I can have 70,000 rows in one work sheet. A friend has suggested access which I am not familiar with and don't know if this will allow 70,000 entries. Can anyone please tell me what the maximum numbers are in both access and excel 2003. Cheers Glinty Max in Excel 2003 is 65536 (in one sheet) whereas Access only limit is your memory -- Regards, Peo Sjoblom ...
Footnotes, after all, are always numbered sequentially and update when you add or remove one. The problem is that each time you add a footnote you get an extra space down at the bottom of the column. The solution? Make a paragraph style for your footnotes that specifies a .1 pt tall size with a 0 (zero) leading, then choose that paragraph style in the Document Footnote Options dialog box.
You won’t use any of the standard List Number styles for SEQ field numbering. You need to create your own style if you want correct indentation and alignment with the tab position of the first word after the number. In this example, I’ll create a new style called Step Number, but you can call it whatever you want. In this example, I’ve also used the default settings for tab and hanging indent positions — you can change these later if you want.

The expression: Nz(DMax(“[PONum]”,”tblPO”),0)+1 will check if a PONum already exists. If it doesn’t it returns a 1, if it does it returns the number incremented by 1. If the number exists, but is 0 it will return a 1. In my blog I advise that number should NOT be generated until the user is ready to save the record. And to immediately commit the record after generating the number. Therefore, there should be no issue about giving them a new number if they go back to it.
If you know in advance that you need outline numbering for your paragraphs, you will want to choose the correct format from the Bullets and Numbering dialog box. Applying one of the preset formats to a paragraph or paragraphs that are already bulleted or numbered applies it to the entire list. There is a specific tab for outline numbers — the Outlined Numbered tab.
To define a sequence by recursion, one needs a rule to construct each element in terms of the ones before it. In addition, enough initial elements must be provided so that all subsequent elements of the sequence can be computed by the rule. The principle of mathematical induction can be used to prove that in this case, there is exactly one sequence that satisfies both the recursion rule and the initial conditions. Induction can also be used to prove properties about a sequence, especially for sequences whose most natural description is recursive.
No matter how light the file might be, if you need 1000 units, that means you send a 1000-page file to the printer if you use Data Merge, that is not as efficient as sending one page and 1000 numbers to insert in the print stream, but to do that you need a plugin, which is what that page Bob directed you is leading up to. I've never used the program Harbs has mentioned, but he's a pretty smart guy and if he says it works well, I'd take a look.
Gift certificates and promotional coupons can play an important role in your marketing strategy by drawing new and repeat customers to your business. However, how can you tell if they are really working to help you develop your business? To make the most of your time and your marketing budget, you need to track the success of your marketing efforts so that you can determine what marketing tactics are effective for which customers.

The blog is pretty much step by step. Where it may not be that specific is, because, these are decisions the developer needs to make. For example, where to put the DMax expression is a matter of your workflow so I can’t tell you where to put it. I’ve given tips in the blog to help you decide. If you are having issues, then please give me more info about your application and I can suggest things.
Hi, this is a great write up. I am very new to InDesign and i print onto a range of products and my first order with sequential numbering came up (serial numbers), I have the template made in illustrator and i also have the numbers added (00001 on all of the art work). A friend told me InDesign has a function for automatically incrasing the numbers by 1 for each art work. I have 105 pieces per template, is there a way to import the design and then sort the number (already text edible) and then save as a pdf then send to print?
Note that we can consider multiple sequences at the same time by using different variables; e.g. {\displaystyle (b_{n})_{n\in \mathbb {N} }} could be a different sequence than {\displaystyle (a_{n})_{n\in \mathbb {N} }} . We can even consider a sequence of sequences: {\displaystyle ((a_{m,n})_{n\in \mathbb {N} })_{m\in \mathbb {N} }} denotes a sequence whose mth term is the sequence {\displaystyle (a_{m,n})_{n\in \mathbb {N} }} .
The best way to do this is to use a primary key. In cases where a query is complex and joins several tables, we may need to use the primary key of the table that’s on the bottom of the relationship hierarchy or possible a concatenation of multiple tables’ unique key so that the expression will be unique and thus we can identify which sequential number we have assigned.
You could stop there and just copy those little bits of text all through your document. But no, we want to make this really, really easy! So we’re going to set up some AutoText entries. What that’s going to do for you (if you’re using Microsoft Word 2010 or above — if you use version 2007, see below for some caveats) is allow you to type the first four letters of your SEQ name and have Word offer to complete the phrase for you, complete with the incrementing number courtesy of the sequence field code we set up earlier.
- [Instructor] In this week's Word tip I'd like to address a question I'm often asked by people working in tables here in Microsoft Word and that is is there a way to quickly have numbers automatically fill up cells in the table much like they might in Microsoft Excel when you have incremental numbers that need to appear by simple clicking and dragging the corner of a cell. Well, yes, it can be done here in the table in Microsoft Word. It's not done the same way but it is just as easy and we're going to do it with this file, LeafAndMortar Inventory 040. If you have the exercise files, open it up. Now, if you don't have the exercise files, just use one of your own tables. All you need is an empty column. You can see here on page one we do have a table for garden tools and inventory and we need to number these and instead going into each cell and typing in a new number that increments by one, we're going to use a trick to have it automatically fill up that way. On page two of this document you can see there's a second table for hardscaping tools, so we want to differentiate these numbers, so we might want, for example, hardscaping tools, their item numbers to start with the letters HT whereas the garden tools up above might need to start with GT and then the number. Keep that in mind as we now go to the column where we want the numbers to appear. All you need to do is select the entire column. In this case we have a header column with a label in there, item number, so we're not going to use the trick of going to the top and clicking when that arrow appears, instead we're going to select the cells where the numbers need to go. With them selected, now we'll go to the ribbon. With the Home tab selected, go to the Paragraph group and just go to the Numbering dropdown arrow. Don't click the numbering button, that's going to add the default number but click the dropdown. You'll see the different numbering options that are already in the numbering library. You can hover over those to see what it's going to look like. You can see the numbers incrementing by one with a period or with brackets. We could use Roman numerals, even lettering here but if we want our own numbers, we go down a little bit further and click Define New Number. Give that a click. You should see the number style one, two, three selected. Click that dropdown and if you wanted to use something other than one, two, three, like Roman numerals or letters, they're there as well but we do want to start with just plain old numbers one, two, three. And you can see what shows up down below. The number format is the number and then a period and we see a sample of what that's going to look like down below. Well, the first thing we can do is click in that field just to the right of the period and hit your backspace key to take it out, we don't need the period. Now, we can move over to the left side of the number by using the left cursor key or you can click if you want just in front of the one and here's where we can add things like letters. GT, for example, then a dash and if that's all we need, we'll see GT-1, two, three etc. all the way down the column. Maybe you'd like to add zeros in there, like 01, 02 etc. You can do that as well. Once you have exactly what you want, simply click OK and it's done and by the way, that number format is there going forward, so the next time you want to use it, it's going to show up in your numbering library in the document as a number format and if it's one you've recently used, it shows up on this list as well, so you can choose it any time you like. Just click in the background and close that up, click outside the table to deselect everything to see how easy that was to get incremental numbers that start with letters and a dash. Now, scroll down to the table on the second page. Now that you know how to do this, you're going to create your own number style that starts with HT, a dash, perhaps a zero and then incremental numbers by following those same steps on this table. That's your homework knowing what you know after this week's Word tip.

Set up a matrix in Excel, one column for each ticket position (stack) and one row for each sheet, plus one for field names. Fill the first column down in consecutive order, then the second, starting where the first column leaves off, and so on. Afet a couple of columns are filled, you can auto fill across the rows, too, so the whole thing takes only a couple of minutes. Name the stacks and use a different field for each position on the page when you do the merge. The trick is to set up using a custom file for the total number of tickets or whatever, divided into the correct number of stacks and sheets.
A single InDesign document can contain up to 9,999 pages, but page numbers can be as large as 999,999. (For example, you can correctly number a 100‑page document that starts on page 9,949.) By default, the first page is a recto (right) page numbered 1. Odd-numbered pages always appear on the right; if you use the Section Options command to change the first page number to an even number, the first page becomes a verso (left) page.
Note this works only because we create a brand new table, add an autonumber column to it as well any other columns we need then insert records into it. It’ll be contiguous – as long we don’t delete any records from the table. Unfortunately, creating a brand new table every time we run this will result in bloat of the Access file – if you can do it in a separate Access file, all the better so that you can compact it when you need to.
It will ask for the number of copies that you want to make and sequentially number each copy.The first time this macro runs, the first copy will be numbered 1 and when it finishes running, it will store in aSettings.Txt file the number that is one more that the number on the last copy.The next time the macro is run, it will start numbering the copies from that number. If when you first start, you want the numbers to start at some number other than 1, run the macro, entering 1 as the number of copies and then open Settings.Txt file and replace the number in the file with the number that you want as the first in the series.At any time thereafter, if you want the series to start at a particular number, you can open that file and replace the number in it with the number that you want to be the first in the series.
Normally, the term infinite sequence refers to a sequence that is infinite in one direction, and finite in the other—the sequence has a first element, but no final element. Such a sequence is called a singly infinite sequence or a one-sided infinite sequence when disambiguation is necessary. In contrast, a sequence that is infinite in both directions—i.e. that has neither a first nor a final element—is called a bi-infinite sequence, two-way infinite sequence, or doubly infinite sequence. A function from the set Z of all integers into a set, such as for instance the sequence of all even integers ( …, −4, −2, 0, 2, 4, 6, 8… ), is bi-infinite. This sequence could be denoted {\displaystyle (2n)_{n=-\infty }^{\infty }} .
(function(){"use strict";function u(e){return"function"==typeof e||"object"==typeof e&&null!==e}function s(e){return"function"==typeof e}function a(e){X=e}function l(e){G=e}function c(){return function(){r.nextTick(p)}}function f(){var e=0,n=new ne(p),t=document.createTextNode("");return n.observe(t,{characterData:!0}),function(){t.data=e=++e%2}}function d(){var e=new MessageChannel;return e.port1.onmessage=p,function(){e.port2.postMessage(0)}}function h(){return function(){setTimeout(p,1)}}function p(){for(var e=0;et.length)&&(n=t.length),n-=e.length;var r=t.indexOf(e,n);return-1!==r&&r===n}),String.prototype.startsWith||(String.prototype.startsWith=function(e,n){return n=n||0,this.substr(n,e.length)===e}),String.prototype.trim||(String.prototype.trim=function(){return this.replace(/^[\s\uFEFF\xA0]+|[\s\uFEFF\xA0]+$/g,"")}),String.prototype.includes||(String.prototype.includes=function(e,n){"use strict";return"number"!=typeof n&&(n=0),!(n+e.length>this.length)&&-1!==this.indexOf(e,n)})},"./shared/require-global.js":function(e,n,t){e.exports=t("./shared/require-shim.js")},"./shared/require-shim.js":function(e,n,t){var r=t("./shared/errors.js"),i=(this.window,!1),o=null,u=null,s=new Promise(function(e,n){o=e,u=n}),a=function(e){if(!a.hasModule(e)){var n=new Error('Cannot find module "'+e+'"');throw n.code="MODULE_NOT_FOUND",n}return t("./"+e+".js")};a.loadChunk=function(e){return s.then(function(){return"main"==e?t.e("main").then(function(e){t("./main.js")}.bind(null,t))["catch"](t.oe):"dev"==e?Promise.all([t.e("main"),t.e("dev")]).then(function(e){t("./shared/dev.js")}.bind(null,t))["catch"](t.oe):"internal"==e?Promise.all([t.e("main"),t.e("internal"),t.e("qtext2"),t.e("dev")]).then(function(e){t("./internal.js")}.bind(null,t))["catch"](t.oe):"ads_manager"==e?Promise.all([t.e("main"),t.e("ads_manager")]).then(function(e){undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined}.bind(null,t))["catch"](t.oe):"publisher_dashboard"==e?t.e("publisher_dashboard").then(function(e){undefined,undefined,undefined,undefined,undefined,undefined,undefined,undefined}.bind(null,t))["catch"](t.oe):"content_widgets"==e?Promise.all([t.e("main"),t.e("content_widgets")]).then(function(e){t("./content_widgets.iframe.js")}.bind(null,t))["catch"](t.oe):void 0})},a.whenReady=function(e,n){Promise.all(window.webpackChunks.map(function(e){return a.loadChunk(e)})).then(function(){n()})},a.installPageProperties=function(e,n){window.Q.settings=e,window.Q.gating=n,i=!0,o()},a.assertPagePropertiesInstalled=function(){i||(u(),r.logJsError("installPageProperties","The install page properties promise was rejected in require-shim."))},a.prefetchAll=function(){t("./settings.js");Promise.all([t.e("main"),t.e("qtext2")]).then(function(){}.bind(null,t))["catch"](t.oe)},a.hasModule=function(e){return!!window.NODE_JS||t.m.hasOwnProperty("./"+e+".js")},a.execAll=function(){var e=Object.keys(t.m);try{for(var n=0;n=c?n():document.fonts.load(l(o,'"'+o.family+'"'),s).then(function(n){1<=n.length?e():setTimeout(t,25)},function(){n()})}t()});var w=new Promise(function(e,n){a=setTimeout(n,c)});Promise.race([w,m]).then(function(){clearTimeout(a),e(o)},function(){n(o)})}else t(function(){function t(){var n;(n=-1!=y&&-1!=g||-1!=y&&-1!=v||-1!=g&&-1!=v)&&((n=y!=g&&y!=v&&g!=v)||(null===f&&(n=/AppleWebKit\/([0-9]+)(?:\.([0-9]+))/.exec(window.navigator.userAgent),f=!!n&&(536>parseInt(n[1],10)||536===parseInt(n[1],10)&&11>=parseInt(n[2],10))),n=f&&(y==b&&g==b&&v==b||y==x&&g==x&&v==x||y==j&&g==j&&v==j)),n=!n),n&&(null!==_.parentNode&&_.parentNode.removeChild(_),clearTimeout(a),e(o))}function d(){if((new Date).getTime()-h>=c)null!==_.parentNode&&_.parentNode.removeChild(_),n(o);else{var e=document.hidden;!0!==e&&void 0!==e||(y=p.a.offsetWidth,g=m.a.offsetWidth,v=w.a.offsetWidth,t()),a=setTimeout(d,50)}}var p=new r(s),m=new r(s),w=new r(s),y=-1,g=-1,v=-1,b=-1,x=-1,j=-1,_=document.createElement("div");_.dir="ltr",i(p,l(o,"sans-serif")),i(m,l(o,"serif")),i(w,l(o,"monospace")),_.appendChild(p.a),_.appendChild(m.a),_.appendChild(w.a),document.body.appendChild(_),b=p.a.offsetWidth,x=m.a.offsetWidth,j=w.a.offsetWidth,d(),u(p,function(e){y=e,t()}),i(p,l(o,'"'+o.family+'",sans-serif')),u(m,function(e){g=e,t()}),i(m,l(o,'"'+o.family+'",serif')),u(w,function(e){v=e,t()}),i(w,l(o,'"'+o.family+'",monospace'))})})},void 0!==e?e.exports=s:(window.FontFaceObserver=s,window.FontFaceObserver.prototype.load=s.prototype.load)}()},"./third_party/tracekit.js":function(e,n){/**
For whatever reason, AllExperts did not let me post a direct reply to your response re: “Ok, what is the ControlSource of the Fixture Number control? It should be: =cboZone & “-” & Format(Me.FNumber,”000″)” and adding “Me.Refresh” to my code (within the last 10 minutes). It just had the “rate this reply”. I added the Me.Refresh and corrected my location of the =cboZone code and it works correctly now.
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.
Even worse (I found out from bitter experience), is that whenever a computer “glitch” (aka “crash”) or “upgrade” (e.g. to a new/different desktop) came along, and our outside IT vendor had to “fix” the “computer” or “system,” (always, of course, at unexpected and unpredictable times), all of my “Auto Text” blocks got “wiped out” (or, I could not find them, even after a few help desk calls), and I had to “reinvent” and “re-keystroke” or “re-save” each of them again (and several times, again). Obviously, frustrating, and largely defeating the efficiency purpose.
It will ask for the number of copies that you want to make and sequentially number each copy.The first time this macro runs, the first copy will be numbered 1 and when it finishes running, it will store in aSettings.Txt file the number that is one more that the number on the last copy.The next time the macro is run, it will start numbering the copies from that number. If when you first start, you want the numbers to start at some number other than 1, run the macro, entering 1 as the number of copies and then open Settings.Txt file and replace the number in the file with the number that you want as the first in the series.At any time thereafter, if you want the series to start at a particular number, you can open that file and replace the number in it with the number that you want to be the first in the series.
Hi Silver, Try going to File/Page Setup/Header-Footer/Custom Header/Should be the button shown in the header box with the # sign in it. Larry -- keithl816 ------------------------------------------------------------------------ keithl816's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=21287 View this thread: http://www.excelforum.com/showthread.php?threadid=498476 ...
You can change the numbers in the list by restarting the sequence or by specifying a new start number. You can change the list's style. You can do anything to this list that you can do to a normal numbered list because it is a numbered list, with one exception: the list, while easy to format, is fixed. If you delete an item, the list updates accordingly, but I haven't found a way to add numbers.
×