How to get rid of the #func! appearing in a query table in ms access?
<p>I created a field called <strong>Expr1</strong> in a query to extract a particular string using the mid function from another field called <strong>HOME_CARD</strong>.</p>

<p>This <strong>HOME_CARD</strong> field has data like for example:</p>

<ul>
<li>IA1234</li>
<li>IA6787 </li>
<li>KL8900</li>
<li>MH5689</li>
</ul>

<p>This is what I've tried to extract only the <strong>IA</strong> portion in my <strong>Expr1</strong> field and it works.</p>

<p>Expr1: Mid([HOME_CARD],InStr(1,[HOME_CARD],"IA"),2)</p>

<p>My issue is, I am getting the #func! error in my query results besides the data like: </p>

<ul>
<li>KL8900</li>
<li>MH5689</li>
</ul>

<p>In MS Excel I could handle this issue by using an <strong>IFERROR</strong> in front of my formula so where <strong>IA</strong> is not found, the cell would just be blank.</p>

<p>Please help me friends, I rather want my query result for those without <strong>IA</strong> to be blank(empty) than return a <strong>#func!</strong> </p>

<p>Thank you in advance.</p>