title: Alias a Caption in Access 2007
body: <p>All right, I've got two tables in my Access 2007 database (well, more than that, but the question applies to these two...):</p>
  
  <pre><code>part
    part_no
    ...
    supplier_id
    special_supplier_id
    ...
  </code></pre>
  
  <p>And</p>
  
  <pre><code>supplier
    supplier_id
    supplier_nm      (NB: Caption="Supplier Name")
    special_supplier_flg
  </code></pre>
  
  <p>Now I've built a query :</p>
  
  <pre><code>SELECT p.part_no, s.supplier_nm, ss.supplier_nm AS special_supplier_nm
  FROM
    part AS p INNER JOIN
    supplier AS s ON p.supplier_id = s.supplier_id INNER JOIN 
    supplier AS ss on p.supplier_id = ss.supplier_id
  </code></pre>
  
  <p>All well and good, and it seems to work for the simple select (if there are any errors in the query itself, it's an artifact of retyping it for the question, and <em>not</em> what the question is about), and should work for code applications as well.</p>
  
  <p>The problem, though, is that if I open the datasheet view of the query, both of the name fields are labeled "Supplier Name". Is there any way around this?</p>