Word: IF statement to merge a field only if another Field is popul

H

HelenC

There are three fields SUBJECT_CODE, STUDENT_NAME, TUTOR_NAME. In all cases,
the Subject_Code field will be populated, but either the Student_Name field
or the Tutor_Name field (never both). I want to put in a command to only
merge the Subject_Code field IF the Tutor_Name field is populated. I have
used the help function and found the example below, which I have tried to
adapt to say IF mergefield Tutor_Name is not blank merge mergefield
Subject_Code or if false put nothing, but it didn't work.

"If the Company data field for a data record contains any information — that
is, if the field is not blank — Word prints text from the CompanyAddress
field. Otherwise, Word prints text from the HomeAddress field."

{ IF { MERGEFIELD Company } <> " " "{ MERGEFIELD CompanyAddress }" "{
MERGEFIELD HomeAddress }" }

This is what I put:
{ IF { MERGEFIELD TM_Name} <> "{MERGEFIELD Socrates_Subject_Code }" " ""}

But no luck. I don't really have any knowledge of programming, everything I
know (which is little) is self taught and done by trial and error! I'd be
very grateful for some help. If I can't solve this, I'm going to have to
redesign my database, which I would rather not do.

Thank you in advance.
 
G

Graham Mayor

{IF{Mergefield Tutor_Name} <> "" "{Mergefield Subject_Code}"}
should work

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
H

HelenC

It worked! Thank you so much.

Graham Mayor said:
{IF{Mergefield Tutor_Name} <> "" "{Mergefield Subject_Code}"}
should work

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
G

Graham Mayor

You are welcome.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 

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

Top