title: MSAccess: Can you have a Function for a WHERE Clause?
body: <p>I'm trying to run a query in Access, but with a function name for a where clause.  Will this work?
  My query still returns all fields, even though the function does get called, and does return a valid search criteria.  It seems like it does not get applied.</p>
  
  <pre><code>SELECT Field1, Field2
  FROM MyTable
  WHERE GetWhereClause("xx", "yy");
  </code></pre>
  
  <p>The Function GetWhereClause will return something like:</p>
  
  <pre><code>Field1 = 'xx' AND Field3 = 'sample'
  </code></pre>