 <p>I think you just need the <a href="http://office.microsoft.com/en-us/access-help/all-distinct-distinctrow-top-predicates-HA001231351.aspx" rel="nofollow">DISTINCT</a> keyword:</p> <p>Basically:</p> <pre><code>SELECT DISTINCT F2, F3, F4 FROM Table; </code></pre>