title: dynamically specify part of table name in SQL query with Access/VBA
body: <p>I'd like to build a dynamic SQL query that can read from different tables depending on a variable.</p>
  
  <p>So I have a snippet like this:</p>
  
  <pre><code>strSQL = "SELECT a100z.f05, a100z.f10, a100z.f23 ..." 
  </code></pre>
  
  <p>I'd like to use a variable to specify the '100', as I have a number of similarly named tables: a100, a200, a300, and so on.  Only one table is used per query, but different for different queries.</p>
  
  <p>The variable used would be the result from field F of another query. </p>
  
  <p>I could just call separate queries each time I need a specific table, but I'm interested in how to do it this way. </p>
  
  <p>Is this possible, and how should it be written?</p>