title: MS Access pull down column via query
body: <p>I have the following table in MS Access:</p>
  
  <pre><code>   ID | column1 | column2           | column3                
     ---+---------+-------------------+--------------
      1 | A       | Publishers        | Publishers
      2 | 01      | Commercial        |  
      3 | 02      | University Press  |  
      4 | B       | Place             | Place 
      5 | 01      | United States     |  
      6 | 04      | Western Europe    |  
      7 | 05      | Other             |  
      8 | C       | Language          | Language  
      9 | 01      | English           |  
     10 | 02      | French            |  
  </code></pre>
  
  <p>I am looking for the following result</p>
  
  <pre><code>   ID |column1  | column2           | column3                
     ---+---------+-------------------+--------------
      1 | A       | Publishers        | Publishers
      2 | 01      | Commercial        | Publishers
      3 | 02      | University Press  | Publishers
      4 | B       | Place             | Place 
      5 | 01      | United States     | Place 
      6 | 04      | Western Europe    | Place 
      7 | 05      | Other             | Place 
      8 | C       | Language          | Language  
      9 | 01      | English           | Language  
     10 | 02      | French            | Language  
  </code></pre>
  
  <p>So basically pulling down column3 heading. I have tried searching the net and asking other pals with some ms access knowledge. But really couldn't find any "pull down" query. Copy/paste wouldn't suffice as this will be performed many times in a day and with much larger data set. Can this be done without vba (looking to get this done through a query)?</p>