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.
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.