title: How do I use the WITH statement in Access?
body: <p>I'm using Access and would like to simplify some of my queries by naming <code>SELECT</code> statements. However, I can't use the <code>WITH</code> statement for some reason. I have tried running the following simple example to illustrate the problem:</p>
  
  <pre><code>WITH T1 AS
  (
  SELECT * FROM [Transactions]
  )
  SELECT * FROM T1;
  </code></pre>
  
  <p>Where <code>Transactions</code> is a table of dates and amounts. When I run this query I get the following error:</p>
  
  <blockquote>
    <p>Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'</p>
  </blockquote>
  
  <p>What am I doing wrong?</p>