I have a database in Microsoft Access 2003 which i am linkin to word 2003 via
mail merge.

I want to check the answer given in the access form is "Yes". If it is i
want to put in a value from a different mergefield, if not, a blank value. At
the moment my if statment reads like this:

{ IF { MERGEFIELD OneDependent } = "Yes" "{ MERGEFIELD Child1Forename }" "" }

A value of MERGEFIELD is all that appears. There is data in the database for
the fields: "OneDependent" and also for "Child1Forename". What am i doing
wrong?