If statement returning true result when should be false

J

JodiMac

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple fields in an IF statement 1
IF field evaluating a bookmark yields incorrect result 2
Merge field+if statement+phone numbers 5
IF fields disappear upon printing 3
Is there no conditional line print function or variable? 2
Mergefield with comma, suppress comma if field blank 3
Page numbering with Merged Document and IF statements 1
Merging pictures - maybe one for Graham? 2

Top