title: Access 2010 Crosstab Query Expression--in One Query
body: <p>I would like to add this expression:</p>
  
  <pre><code>([2013]/[2012]-1) AS [Change%]
  </code></pre>
  
  <p>As a field to the crosstab query below:</p>
  
  <pre><code>TRANSFORM 
        Sum(Data.Spending)
  SELECT 
        Data.Category
  FROM
        Data
  WHERE 
        (((Data.Year)="2012" Or (Data.Year)="2013"))
  GROUP BY 
       Data.Category
  PIVOT 
       Data.Year;
  </code></pre>
  
  <p>This is solved through using another table in this thread: <a href="https://stackoverflow.com/questions/11123168/access-2007-crosstab-query-expression">Access 2007 Crosstab Query Expression</a></p>
  
  <p>But for my purposes I need to have everything together in one query.</p>
  
  <p>This is because I am writing SQL in another program, <a href="http://www.ljzsoft.com/ppt-report.htm" rel="nofollow noreferrer">http://www.ljzsoft.com/ppt-report.htm</a>, which uses the query to directly access an Access database. </p>