Home |
Search |
Today's Posts |
#1
|
|||
|
|||
If statement returning true result when should be false
I've tried to resolve this myself, but have given up!
I'm using office 2003 and merging data from an Excel spreadsheet into a word document. I want to conditionally print a line (the Objective) when data changes in one of the Excel columns. {If {MergeRec} = 1 {SET MyIndex " "} {if MyIndex {Mergefield Objective} "Objective: {Mergefield Objective} " "" } {SET MyIndex {Mergefield Objective} } {Mergefield QuestionText} A. {Mergefield Answer_a_text} B. {Mergefield Answer_b_ text} IF {Mergefield Answer_c_text} "" "C. " ""}{Mergefield Answer_c_text} IF {Mergefield Answer_d_text} "" "D. " ""}{Mergefield Answer_d_text} The results are inconsistent. For the first record, the Objective prints fine. When the objective changes the first time, the new (second) Objective is not printed. But on about the fifth change in objectives, it is again printed. I have even gone so far as to print the values of the MyIndex field and the Objective field for each record and I can see where they are different but the If MyIndex = Objective test is evaluated as true!! Is there a character limit? Some objectives are up 149 characters. Any suggestions? Thanks so much, JodiMac |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Table in a Form | Tables | |||
Convert numeric value into english word | Microsoft Word Help | |||
CardText Field Switch | Mailmerge | |||
macro problems | New Users | |||
How do I turn dollar amounts into words? | New Users |