title: MS Access: Referring to a dynamic column name?
body: <p>Two of the columns in Query A are labeled 2012 and 2011.</p>
  
  <p>However, next year, the columns will be 2013 and 2012. This is because those columns are part of a crosstab where the name is done via the year() function.</p>
  
  <p>Anyway, I am using a new query to add a column that subtracts the values in the two year columns, but I don't know how to refer to those columns dynamically.</p>
  
  <p>e.g. I could easily add a column </p>
  
  <pre><code>Difference: [2012 Revenue] - [2011 Revenue]
  </code></pre>
  
  <p>But this would stop working next year.</p>