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...
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!!
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.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
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...

The standard method for displaying a page number in InDesign is to insert an Automatic Page Number Marker into a text frame (Text menu: Insert Special Character: Marker: Current Page Number). This is typically done on your master page(s) so that the page number will appear on every page using that master. If you wish to hide the page number on pages in your document, just use a different master that does not include the marker (or use the “None” master if you do not wish to display any master page items).
This tip was very helpful. Now I have been able to automatically number dozens of examples in a linguistics paper, and as I revise the paper and insert new examples between the existing examples, the numbering is automatically adjusted. Now the next step is how to use bookmarks for the references to the examples in the text of the paper. The references need to point to specific examples, and need to be automatically adjusted when the numbering of examples is adjusted. Any ideas on how to do this?

One solution is to format the heading with the style and follow it with a hidden paragraph mark. You should format the text in the next paragraph with a style that is not included in the Table of Contents. A hidden paragraph mark keeps the text together on one line when it is printed, even though it is actually two separate paragraphs. The Table of Contents command picks up only those paragraphs with heading styles and places them into the Table of Contents.
You can add a chapter number variable to your document. Like page numbers, chapter numbers can be updated automatically and formatted and styled as text. A chapter number variable is commonly used in documents that are part of a book. A document can have only one chapter number assigned to it; if you want to divide a single document into chapters, you can create sections instead.
If the second number on your raffle ticket is one higher than the first number, you must have accidentally put the <> tag after the first number (causing the next number, on the same ticket, to increase by one). You only need the <> after the second number on each ticket, so the next ticket gets a new number. (But you don’t need it on the final ticket on the **page**, because the next **page** automatically gets a new number)

It's also possible to consecutively number list items in InDesign. Create a text frame for your list and click the numbered list button to insert a list. Type your list items, pressing your "Enter" key between items. InDesign consecutively numbers the list automatically; you can change the number it begins with and the style of the numerals. Press your "Alt" key (Windows) or "Option" key (Mac OS) while clicking on the numbered list button to open a dialog where you can modify those options.
(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){/**
Is there a way to auto number files with the file number (less .jpeg) and save without having to let my computer grind to a halt, as it does using Automate, contact sheet. The objective is to create a preview set for distribution to clients with the file number annotated at bottom centre. Also, is there any way of creating the text/font/colour/stroke of my choice?
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)
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. A Current Page Number marker must be set on pages in order to use this feature. The Current Page Number is a special character inserted in a text frame on a page or master page (recommended) where the page number will appear, by selecting Type>Insert Special Character>Markers>Current Page Number.
So I spent some time trying to figure it out, playing with Normal.dotm and the various styles (List paragraph, List Number, List Bullet etc etc). And finally, when I've got Normal.dotm open (i.e. I'm editing that template file), I get my result: I apply a standard numbered list, and it comes up flush left (i.e. not indented) and hanging at 1.0cm (cos I don't use inches...) and with a tab stop applied at 1.0cm as well - funky stuff!
I have screen shots of what I have in my db, where can I send it to you (it is in word format) so that you can take a look at it to see what I am doing wrong. I took a screen shot of what is listed for the button and I took a screen shot of the text box Job No. I don’t know how to bound anything other than put the code behind the button and putting the Job_No in the code as you stated. I understand what you are saying, but I thought if I put the text box name Job No in the code behind the button then it would be bound to my table with the Job No field. Heeeelllllppppp!!!! I am sorry that I can’t seem to grasp this….but appreciate all of your help!
One of the easiest ways to begin applying numbers is by starting to type a numbered list. Word recognizes that you are creating a list and responds accordingly by converting text that you type into numbered items. The number scheme, delimiter characters that mark the beginning or end of a unit of data and formatting are all based on what you have typed.
So I spent some time trying to figure it out, playing with Normal.dotm and the various styles (List paragraph, List Number, List Bullet etc etc). And finally, when I've got Normal.dotm open (i.e. I'm editing that template file), I get my result: I apply a standard numbered list, and it comes up flush left (i.e. not indented) and hanging at 1.0cm (cos I don't use inches...) and with a tab stop applied at 1.0cm as well - funky stuff!
All posts and other information available at Signs 101 should be viewed as the opinion only of the poster. No claim is made that any information is accurate. As such, each reader should not rely on any information available here as accurate and should independently verify such accuracy. In addition, no claim is made that posts made here will be free from profanity, obscenity, rude, hurtful, libelous or insulting opinions of the poster. Such posts should, however, be reported to an Administrator for review.
Changing the numbering display affects how pages are indicated in the InDesign document, as in the Pages panel and in the page box at the bottom of a document window. The numbering display also affects how you specify page ranges when printing and exporting the document. However, the numbering display does not change the appearance of page numbers on document pages.
It's also possible to consecutively number list items in InDesign. Create a text frame for your list and click the numbered list button to insert a list. Type your list items, pressing your "Enter" key between items. InDesign consecutively numbers the list automatically; you can change the number it begins with and the style of the numerals. Press your "Alt" key (Windows) or "Option" key (Mac OS) while clicking on the numbered list button to open a dialog where you can modify those options.

    Numbering raffle tickets can be a rough project to tackle without the right tools. Luckily you can number raffle tickets or any other document or form with a desktop publishing software program you may already own like Microsoft Word, Publisher, Adobe Indesign or CorelDraw or any desktop publishing software that has a mail merge function.  Then all that is needed is a program that can create the mail merge file you need to number your tickets like starting number, ending number, prefix and so on. And for that program we suggest Number-Pro.
i’ve had to do tons of this lately and found that for the amounts of tickets being done (e.g. 7000 x 10 tickets + cover & mailer) that chuckT’s solution almost 2 years ago is similar to what i use. would be interested to know if others doing similar VDP are using a wholly indesign/excel solution, or if specific VDP software such as XMPie are being used.
×