Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
Oh my! I stepped away for a couple of days and came back to lots of great
responses. I am trying macropod's and Maxey's use of a numerical test, coupled with an INCLUDETEXT command when it returns 1. Works great. Thanks for all the teriffic dialog/feedback. "Peter Jamieson" wrote in message ... Indeed:-) I certainly hope Lara Z has some ideas to go on now! Peter J. "macropod" wrote in message ... Hi Peter & Greg, In either case, you're going to need to set the 'County' value via the mailmerge. Unless you're planning to do this via a SET field that I haven't seen explained (eg {SET County {MAILMERGE CountyName}}), you'd both need to use {MAILMERGE County} instead of {County}. Cheers "Peter Jamieson" wrote in message ... You can probably simplify that using COMPARE via e.g. { IF { =({ COMPARE { County } = "Hillsborough" }+{ COMPARE { County } = "Pineallas" }+{ COMPARE { County } = "Lake" }+{ COMPARE { County } = "Orange""1""0" }+{ COMPARE { County } = "Brevard" }+{ COMPARE { County } = "Indian River" }+{ COMPARE { County } = "Volusia" }+{ COMPARE { County } = "Oceola" }) } 0 "Test Sat" "Test Unsat" } Peter Jamieson "Greg Maxey" wrote in message ... Lara, I found some material that I had squirreled away on Word math fields. A bright fellow that goes by Macropod shows us a relatively simple process: { If { =({ IF { County } = "Hillsborough""1""0" }+{ IF { County } = "Pineallas""1" "0"}+{ IF { County } = "Lake""1""0" }+{ IF { County } = "Orange""1""0" }+{ IF { County } = "Brevard""1""0" }+{ IF { County } = "Indian River""1""0" }+{ IF { County } = "Volusia""1""0" }+{ IF { County } = "Oceola""1""0" }) } 0 "Test Sat""Test Unsat } Basically you just set up 8 condition equal 0 or 1 and add then up. One and only one can be 1 and if any one is 1 then the condition {=(1)} 0 is met and the true result displayed. As mentioned earlier, you should replace "Test Sat" with an IncludeText field or AutoText field. -- Greg Maxey/Word MVP See: http://gregmaxey.mvps.org/word_tips.htm For some helpful tips using Word. Lara Z wrote: I am trying to code a merge document that will insert an additional two-page document if the 'COUNTY' field is one of eight counties. The additional document is the same for all eight counties. In WordPerfect this could be done simply with the SWITCH/ENDSWITCH construct. I know there is no equivalent in Word, but is there any easier way to do this than doing eight back-to-back IF statements with the same (redundant) two pages of text inserted in each "then" part of the IF statement? Is there an OR operator in Word that might help accomplish this? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enter data in 1 text form field & have multiple locations fill | Microsoft Word Help | |||
Zip Field Jumps Out Of Place | Mailmerge | |||
Make merged field bold if merged field > 3 | Mailmerge | |||
How do I use the PRINT field code to ... | Microsoft Word Help | |||
Text Form Field Ref in Footer Won't Update on Screen | Microsoft Word Help |