title: Adding a Constant Row Result to SQL Query - MS Access
body: <p>Say I have a table "tblItems":</p>
  
  <pre><code>*ID*    |     *Name*
  1       |   First Item
  2       |  Second Item
  </code></pre>
  
  <p>and I want this to be populated in a drop-down in a form. How would I add a row:</p>
  
  <pre><code>ALL     |    SHOW ALL
  </code></pre>
  
  <p>to become</p>
  
  <pre><code>*ID*    |     *Name*
  1       |   First Item
  2       |  Second Item
  ALL     |    SHOW ALL
  </code></pre>
  
  <p>with one query to place in the <code>Row Source</code> for the combo box? I haven't been able to find Access syntax to do this..</p>
  
  <p>AFAIK, I need syntax similar to</p>
  
  <pre><code>SELECT ID, Name FROM tblItems
  UNION
  SELECT 0, "All" FROM SOME.SYSTEM.DUMMY.TABLE
  </code></pre>
  
  <p>what I can't find is Access' version of that dummy table. I don't really want to have a separate table just to store one row for one form... but from what I've been reading I may have to.</p>