title: Undefined function 'mid' in expression in MS Access
body: <p>I am trying to write a query in MS Access, and receiving the error "Undefined function 'mid' in expression' when I try to execute it.</p>
  
  <pre><code>SELECT MID([ColumnName], 4,2)
  FROM tblName
  </code></pre>
  
  <p>As I understand it, the MID function is the MS Access equivalent to Substring. Both the table and the column definitely exist.  What could be causing this error?</p>