Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / April 2005

Tip: Looking for answers? Try searching our database.

OR statement

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
JCSadie - 25 Apr 2005 17:49 GMT
Need Syntax.  I keep getting a syntax error.  
Peter Jamieson - 25 Apr 2005 18:24 GMT
Can you be a bit more specific please? What do you want to "OR" ?

Peter Jamieson
> Need Syntax.  I keep getting a syntax error.
Graham Mayor - 25 Apr 2005 18:27 GMT
Perhaps if you explained exactly what it is you are trying to do, someone
may be able assist with the correct syntax.

Signature

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> Need Syntax.  I keep getting a syntax error.
JCSadie - 25 Apr 2005 18:51 GMT
Word 2002 ..IF statement with an OR..There was a listing in here last week..I
should have saved it out.

{if {=or({mergefield doc_param} = "ap,*"), =or({mergefield doc_param} =
"ap&pop,*")} = 1 "Blah Blah Blah" "?????????"}

Not sure it should be = 1 for True.  Did this because I was thinking of the
AND conditional.  Where do you end the parenthesis? Do you add the second =or
after a , or a ;? Enough? That is what I meant by needing syntax!

> Perhaps if you explained exactly what it is you are trying to do, someone
> may be able assist with the correct syntax.
>
> > Need Syntax.  I keep getting a syntax error.
Peter Jamieson - 25 Apr 2005 19:10 GMT
> Word 2002 ..IF statement with an OR..There was a listing in here last
> week..I

Try Google Groups to find messages.

The building blocks are:

{ =or(expression1,expression2) }

returns 1 if either expression1 or expression2 or both expressions are 1, 0
otherwise

within an = field, or functions can be nested

{ =or(expression1,or(expression2,expression3)) }

When you need to do a comparison, you can use

{ IF "{ MERGEFIELD doc_param }" = "ap.*" "1" "0" }

so then you can do

{ =or( IF "{ MERGEFIELD doc_param }" = "ap.*" "1" "0" },expression2)  }

or you can use

{ COMPARE "{ MERGEFIELD doc_param }" = "ap.*" }

which returns 1 for "they match" and 0 for "they do not match", so you can
use

{ =or({ COMPARE "{ MERGEFIELD doc_param }" = "ap.*" },expression2) }

But as long as "False" is always expressed as 0 and "True" is always
expressed as 1 (which is what happens if you do your comparisons using
COMPARE, or IF as above), you can do multiple or s within an = field using
simple addition, e.g.

{ ={ COMPARE "{ MERGEFIELD doc_param }" = "ap.*" }+
{ IF "{ MERGEFIELD doc_param }" = "ap.*" "1" "0" } }

should return 0 if neither expression is true and >0 otherwise.

Often, people want to return one text if one or more of several conditions
is true and another text otherwise. In that case, you usually need to wrap
the whole {=} field up in a final IF, e.g. using the above addition approach

{ IF { ={ COMPARE "{ MERGEFIELD doc_param }" = "ap.*" }+
{ IF "{ MERGEFIELD doc_param }" = "ap.*" "1" "0" } } = 0
"it's all false" "at least one of them is true" }

Peter Jamieson

> Word 2002 ..IF statement with an OR..There was a listing in here last
> week..I
[quoted text clipped - 13 lines]
>>
>> > Need Syntax.  I keep getting a syntax error.
JCSadie - 26 Apr 2005 01:55 GMT
OK, I keep getting syntax errors, it sometimes points to the comma and
sometimes to the parenthesis.  This is what I have

{=or({doc_param} = "AP", {doc_param} = "ap")} What else goes in here to tell
it what to do?  

If I put it in an if statement then would it look something like this ?  do
I set it equal to one?  Shouldn't it automatically know whether it is true or
false?  

{if {=or({doc_param} = "AP", {doc_param} = "ap")} = 1 "AP is True" "AP is
False"}

> > Word 2002 ..IF statement with an OR..There was a listing in here last
> > week..I
[quoted text clipped - 66 lines]
> >>
> >> > Need Syntax.  I keep getting a syntax error.
Peter Jamieson - 26 Apr 2005 08:54 GMT
The point is that you can't just do

{doc_param} = "AP".

Instead, you have to do

{ COMPARE { doc_param } = "AP" }

Which makes everything more unwieldy, but means that the following should
work:

{=or({ COMPARE {doc_param} = "AP" }, { COMPARE {doc_param} = "ap" })}

Then you probably need to wrap that up:

{ IF  {=or({ COMPARE {doc_param} = "AP" }, { COMPARE {doc_param} = "ap" })}
= 0
"doc_param is neither AP nor ap" "doc_param is AP or ap" }

In this case the following might be what you need:

{ IF { doc_param \*Upper } = "AP" "doc_param is ap,aP,Ap or AP" "doc_param
is none of ap,aP,Ap or AP" }

Peter Jamieson

> OK, I keep getting syntax errors, it sometimes points to the comma and
> sometimes to the parenthesis.  This is what I have
[quoted text clipped - 90 lines]
>> >>
>> >> > Need Syntax.  I keep getting a syntax error.
JCSadie - 26 Apr 2005 21:52 GMT
Thank you so much for your information.  The or statements are beginning to
work.  Your are greatness!

> The point is that you can't just do
>
[quoted text clipped - 116 lines]
> >> >>
> >> >> > Need Syntax.  I keep getting a syntax error.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.