title: How to get SQL from column/query schema in Access
body: <p>Given this QueryDef:</p>
  
  <pre><code>"SELECT Column1, Column2, "Prefix" + SomeColumn AS Column3 FROM SomeTable"
  </code></pre>
  
  <p>Is there a way using either VBA or SQL to extract ""Prefix" + SomeColumn" as the definition of the SomeColumn field in the SomeTable table?</p>
  
  <p>Essentially I need to run a report on a list of queries of all the columns that have custom SQL in the definition.  I already have a list of the queries/columns, I'm just struggling to pull out the actual code.</p>