Microsoft Access: Multi-valued field is not valid in the expression
<p>In <strong>Access</strong> I created two tables. One being an input dataset and one being an enrichment table to the input set. In the enrichment table I created multi-valued fields. The reason why I created these fields is in the fact that a combination of the selected multi-valued fields are to be rolling up to a specific ID number (named the <em>LCR DA 73 Main</em>). I have tried connecting the tables but, unfortunately get the following error:</p>

<p>"The multi-valued field .............is not valid in the expression ..........."</p>

<pre><code>The initial database = LM_AAVNL_P10_2016_New
The enrichment table = C73_Outflow
The expression = RCOA_Sel: 
IIf([C73_Outflow]![Reporting CoA_New]=[LM_AAVNL_P10_2016_New]![Reporting CoA];"Y";"N")
</code></pre>

<p><a href="https://i.stack.imgur.com/KsRGp.jpg" rel="nofollow noreferrer">Click here to see the Query</a></p>

<p><a href="https://i.stack.imgur.com/F1iO5.jpg" rel="nofollow noreferrer">Click here to see the multi-valued table</a></p>

<blockquote>
  <p>The rollup should be that all related reporting COA's, Relation Class and the BIS indicator 1 go to LCR DA 1.1.2.1.2.</p>
</blockquote>