title: How to create a new column in a select query
body: <p>In MS Access, I want to insert a new column into the returned result of a select query. The new column has the same value for every row. For example, my select returns columns A, B and I want C to be the new column created by the select query:</p>
  
  <pre><code>A   B   C
  ----------
  a1  b1  c
  a2  b2  c
  a3  b3  c
  </code></pre>