Merge Using IF statement

[Debbie]

I'm using Office XP and am using a database query from
Access as my data source, merging into a letter in Word.
The problem I am having is this:
In the salutation line, I would like to use the Nickname
(Nickname field), if there is one; otherwise, I'd like to
use the First_Name field. I have tried every contortion
of the IF statement, but I still do not get what I'm
looking for. Is there anyone that can help? My boss is
not very open to new ways of doing things, so I've got to
get this working before she decides we should ditch the
database and go back to entering information in 20
different places (drives me crazy!). Thank you VERY much
for your help.

 

[Graham Mayor]

{IF {Mergefield Nickname} <> "" "{Mergefield Nickname}" "{Mergefield
First_Name}"}
Use CTRL+F9 to insert the field boundaries.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail (e-mail address removed)
Web site www.gmayor.dsl.pipex.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>