title: How can I test and handle a #Func! error from within a query?
body: <p>I have an Access query that has a some what complex field on it.  Basically, I'm searching for a certain value, based on other derived criteria.  The function either works, or it gives a <code>#Func!</code> error. There are a few reasons why I may get an error.  That is fine, because in those cases I want to return <code>Null</code>.</p>
  
  <p>How can I test and handle a <code>#Func!</code> error from within a query?  Also, I tried to wrap the expression in an <code>IsError()</code> method, and handle that case.  That still didn't work.</p>