title: Can i execute query in iif function
body: <p>I want to know can i run a query in iif function used in ms access database. My case </p>
  
  <pre><code>Select field1,(iif(3&lt;4,'Select * from tbl1','select * from tbl2')) from tblmain
  </code></pre>
  
  <p>I am facing syntax error when i try to executed query like that whats the problem</p>