title: Using math functions in Sql with MS Access
body: <p>I designed a query in SQL View using MS Access:</p>
  
  <pre><code>select floor(num1) from t1;
  </code></pre>
  
  <p>When I run it, I get "undefined function floor".</p>
  
  <p>I get similar errors for <code>Ceil</code>, <code>Mod</code>,<code>Power</code>, <code>Sign</code>, <code>Sqrt</code>, <code>Trunc</code>, and <code>initcap</code> functions.</p>
  
  <p>Does the Access database engine's SQL syntax have equivalent functions?</p>