title: Query for unique values
body: <p>I have the following database table in Access:</p>
  
  <pre><code>Field1 | Field2
  A | 1
  B | 1
  C | 2
  D | 2
  B | 3
  O | 3
  L | 3
  </code></pre>
  
  <p>I want to develop a query in Access (preferably without using SQL) to select all values in Field2 corresponding to an occurence of the value "B" in field 1. This query should yield</p>
  
  <pre><code>Field1|Field2
  A | 1
  B | 1
  B | 3
  O | 3
  L | 3
  </code></pre>