title: MS Access Equivalent for T-SQL query
body: <p>I have a query some thing like this :</p>
  
  <pre><code>convert(varchar(7), [DateDelivered], 120) As Month_Delivered 
  </code></pre>
  
  <p>This does not seem to work with Access ODBC linked tables. what would be the equivalent for above ?</p>
  
  <p>I  have tried with CSTR , does not seem to work . I am getting error like : </p>
  
  <pre><code>Syntax error: missing operator in query expression .
  </code></pre>
  
  <p>Any thoughts on this ?</p>