title: How to use ISNULL function in ms-access
body: <p>I have database table with following fields</p>
  
  <p>FieldId
  FieldGroupId
  FieldName</p>
  
  <p>I need to select FieldGroupId from Fields table where FieldId = "?" and iff FieldGroupId is empty it should return some default value.</p>
  
  <p>Following query does not work if FieldID is not present in databse.</p>
  
  <pre><code>select IIf(IsNull(FieldGroupID),"AA",FieldGroupID) from Fields where FieldID ='ALPHAA'
  </code></pre>