Solved

COMPARE STATEMENT - WORD Mergedfields

Posted on 2006-12-01
7
285 Views
Last Modified: 2008-01-09
Simply put, why doesn't this produce a "bob". All I can manage is a "{"


{ IF { = AND ( { COMPARE "A" = "A" }, { COMPARE "B" = "B" } ) } = 1 "bob" "bob1" }
0
Comment
Question by:dlangman
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
7 Comments
 
LVL 76

Expert Comment

by:GrahamSkan
ID: 18057913
I think it must be a bug. I get the same in Word 2000. I can test it in Word 2003 on Monday, unless that is the version that you are using anyway. Are you?
0
 

Author Comment

by:dlangman
ID: 18069299
I am using office 2003.
0
 
LVL 6

Accepted Solution

by:
Ken Turner earned 300 total points
ID: 18100640
The expression works fine for me exactly as presented, and returns "bob".

I am using Word 2003 (11.8106.8107) SP2

How did you build it?  I simply did Ctrl-F9 to create { }'s where needed, and then typed/copied/pasted the other bits into them.

0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 76

Expert Comment

by:GrahamSkan
ID: 18101299
Hi Ken, how are you doing?

Thanks for that prompt - I just tried it in 2003 and it works for me too.

So I tried it again on my (Word 2000) laptop system, and would you know, I can't make it go wrong again. Unfortunately I didn't save my previous efforts.

So dlangman, try typing the whole thing in again - it might just work. If it does, give Ken the points. His intervention will have saved the day.
0
 
LVL 6

Expert Comment

by:Ken Turner
ID: 18101371
Graham, I'm fine - good to hear from you.

Your suggestion re the points is very generous, thanks.

Happy Christmas to all our readers!
0
 

Author Comment

by:dlangman
ID: 18102309
I just updated my office to the version KenTurner mentioned, typed it from scratch again and when I complete the merge I am returning this error message: Error! Unknown op code for conditional.
0
 
LVL 76

Assisted Solution

by:GrahamSkan
GrahamSkan earned 200 total points
ID: 18102378
I go that just now, but I had typed (leaving no space between the = and the 1):

} =1 "bob"


instead of

} = 1 "bob"
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

PaperPort has a feature called the "Send To Bar". It provides a convenient, drag-and-drop interface for using other installed software, such as Microsoft Office. However, this article shows that the latest Office 2016 apps (installed with an Office …
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

756 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question