Re: Can I compare more than two merge field values using =AND or =
by UmhpYW5ub24 » Mon, 15 Jun 2009 06:45:01 GMT
Thanks Doug.That may, unfortunately, be where I'm at. I'm hoping there's an
alternative because I'm already close to the max number of columns in the
data source, and I need to compare the mergefields in multiple, unique
combinations, which is why I'm hoping to do it in the word doc itself.
Thanks again!
Re: Can I compare more than two merge field values using =AND or =
by OExlb25pZTg » Thu, 09 Jul 2009 19:39:01 GMT
Hi there,
I'm trying to use the OR function in my Word 2003 document (dutch version),
but I can't get it to work.
I get the following reaction when merging to a new document: Error! Unknown
operator in precondition
Does anyone have an idea why this doesn't work??
Re: Can I compare more than two merge field values using =AND or =
by Graham Mayor » Thu, 09 Jul 2009 20:11:11 GMT
Did you enter all the brackets with CTRL+F9?
--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://www.**--****.com/
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Re: Can I compare more than two merge field values using =AND or =
by OExlb25pZTg » Thu, 09 Jul 2009 21:01:05 GMT
es I did. I even followed the help Peter Jamieson has given in the topic
titled "=AND" He says:
then use right-click and toggle field codes to see the result of that part
of the whole construct to see if you can detect which part is causing the
problem.
If I click toggle field code(I'm not sure if that's the correct English word
for this option, I'm translating from the Dutch version of Word), it seems
every part of the function is working. When I click toggle field code for the
different mergefields first I get:
{ IF { =1+1+1}>0 "True text" "False text"}
If I go a step further and click toggle field code for {=1+1+1} I get:
{ IF 3>0 "True text" "False text"}. So far so good, you'd say, but when I
click toggle field code for the last step I get:
Error! Unknown operator in precondition
Hope I've explained my actions in an understandable way, otherwise let me
know.
gr leonie
"Graham Mayor" wrote:
Re: Can I compare more than two merge field values using =AND or =
by Graham Mayor » Thu, 09 Jul 2009 22:16:06 GMT
Put a space either side of >
thus
{IF 3 > 0 "True text" "False text"}
--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
8Leonie8 wrote:
Re: Can I compare more than two merge field values using =AND or =
by macropod » Fri, 10 Jul 2009 16:08:17 GMT
Hi Graham,
Only the space after the operand is required - as shown in my post. Spaces before & after won't do any harm, though.
--
Cheers
macropod
[Microsoft MVP - Word]
"Graham Mayor" < XXXX@XXXXX.COM > wrote in message news:esRqB58$ XXXX@XXXXX.COM ...
Re: Can I compare more than two merge field values using =AND or =
by Graham Mayor » Fri, 10 Jul 2009 23:34:43 GMT
greed - though no space will produce the error.
--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
macropod wrote:
Similar Threads:
1.How can I compare and merge two documents using Word startup s
Thank you for your answer, but that's not what I meant. I want to compare and
merge documents by starting Word from command prompt with some parameters.
This way this comparison operation could be started from another program.
"Sheila D" wrote:
> If you are using Word 2003 there is an option on the Tools menu, Compare and
> Merge Documents which should do the trick
>
> "Artem" wrote:
>
> > I would like to compare two Word documents by invoking Word from a 3rd party
> > program or a script with some comman-line switches.
> >
> > At this moment all I'm able to do is to open multiple documents, but not to
> > compare them.
2.How can I compare and merge two documents using Word startup switc
I would like to compare two Word documents by invoking Word from a 3rd party
program or a script with some comman-line switches.
At this moment all I'm able to do is to open multiple documents, but not to
compare them.
3.compare two files and merge rows base on a matching word within these two rows
4.Can I compare more than two merge field values using =AND or =OR?
I'm working in Word 2007. I have a list of mergefields (anywhere between 3
and 7 depending) that I would like to test the values of - if all of them
come back true, return one block of text, else return another block of text.
It works fine when I try and compare the values of two mergefields:
{IF { = AND ( { COMPARE {Mergefield 1} = "Y"}, {COMPARE {mergefield 2} <> 2
} ) } = 1 "true" "false" }
but as soon as I try and compare the values of three or more mergefields:
{IF { = AND ( { COMPARE {Mergefield 1} = "Y"}, {COMPARE {mergefield 2} <> 2
}, { COMPARE {mergefield 3" = "text" } ) } = 1 "true" "false" }
it breaks. Is there a way to expand beyond two comparisons, using either the
=AND or the =OR formulas? I'd rather not start nesting piles of these if I
can help it. Thanks muchly!!
5.When merging and using a compare field, how do I jump from S3 to S
I am using a compare field in a merge document. If the result is true, I want
the system to jump to section 3 of the document. If it's false, I want the
system to jump to section 1. Alternatively, if section jumping isn't
something supported, could I use book marks for this?
Any help is appreciated.
Hope
6. if...then comparing field values?
7. Compare two fields from a data source before inserting text
8. compare two numerical fields