title: query with IIF statement
body: <p>I am responsible for producing a set of name badges for an upcoming class reunion.  Have everything set up and have been able to produce the correct output for those attending the reunion.  </p>
  
  <p>What I want to do is place parenthesis around the maiden names of the married women attending the reunion.  Right now the maiden name is being displayed on the badge, but without parenthesis.</p>
  
  <p>I have placed the following expression in the MaidenName field of the query I have written, but nothing is happening, at least this expression did not produce any error messages when I ran it.</p>
  
  <pre><code>IIf([MaidenName]="IsNull",[MaidenName]=" ",([MaidenName]=("("+[MaidenName]+")")))
  </code></pre>
  
  <p>When I entered the expression the first time the IsNull was without quotes.  When I ran the
  the query the quotes were place around the IsNull statement.  The query ran, but there were no parenthesis around the maiden name on the output.</p>