<div>
SELECT DISTINCT &nbsp;FName, LName and Email FROM yourTable<br />
<br />
should do it. &nbsp;Another method:<br />
<br />
SELECT &nbsp;FName, LName and Email<br />
FROM yourTable<br />
GROUP BY &nbsp;FName, LName and Email
</div>


<div>
@Dale<br />
<br />

<blockquote>
LName <b>and</b> Email
</blockquote>
your use of &quot;and&quot; is incorrect in the Select clause<br />
<br />
==================<br />
This query will give you a candidate list of duplicates:<br />

<pre><code class="code-1 nolinks" id="code-20-40437732-1"><span>SELECT  FName, LName, Email, Count(Email) As CountOfEmail</span>
<span>FROM myTable</span>
<span>GROUP BY  FName, LName, Email</span>
<span>Having Count(Email) &lt;&gt; 1</span>
</code></pre>
<br />
However, it produces a non-updatable dataset. &nbsp;<br />
Workarounds:<br />
* Use the above query to populate a new table. &nbsp;Then link the delete candidate table with your original table to do the deletes.<br />
* Create a delete query. &nbsp;The following query requires that you have some autonumber field. &nbsp;I am using ID to denote such a field.<br />

<pre><code class="code-1 nolinks" id="code-20-40437732-2"><span>Delete * </span>
<span>FROM myTable</span>
<span>WHERE</span>
<span>DCount(&quot;EMail&quot;, &quot;myTable&quot;, &quot;LName=&quot;&quot;&quot; &amp; LName &amp;&quot;&quot;&quot; and FName=&quot;&quot;&quot; &amp; FName &amp; &quot;&quot;&quot; and EMail=&quot;&quot;&quot; &amp; EMail &amp; &quot;&quot;&quot;) &lt;&gt; 1</span>
<span>And </span>
<span>ID &lt;&gt; DMin(&quot;ID&quot;, &quot;myTable&quot;, &quot;LName=&quot;&quot;&quot; &amp; LName &amp;&quot;&quot;&quot; and FName=&quot;&quot;&quot; &amp; FName &amp; &quot;&quot;&quot; and EMail=&quot;&quot;&quot; &amp; EMail &amp; &quot;&quot;&quot;)</span>
</code></pre>
</div>


<div>
@aikimark,<br />
<br />
yeah, tough morning.<br />
<br />
@contrain<br />
<br />
SELECT DISTINCT &nbsp;FName, LName, Email FROM yourTable<br />
<br />
or <br />
<br />
SELECT &nbsp;FName, LName, Email<br />
FROM yourTable<br />
GROUP BY &nbsp;FName, LName and Email <br />
<br />
Both of these will give a list of all of the FNAME, LNAME, Email combinations. &nbsp;If you truely want to clean out the duplicates, take a look at aikimarks post.
</div>


<div>
Dale Fye,<br />
<br />
<br />
When I run either of your queries, I get the &quot;Syntax Error in FROM Clause&quot; message. Maybe I'm putting it in the wrong place, I am creating a query, and changing the generic name yourTable to the name of my table which is SFOfficeList (I'm putting it in the SQL window) and running it. Am I putting your code in the wrong place?
</div>


<div>
aikimark,<br />
<br />
when I run your delete query and change your generic table name to the real name of my table I get a message stating &quot;The expression you entered has an invalid .)dot) or ! operator or invalid parentheses.&quot;<br />
<br />
What I am doing is going into the query window, choosing Delete, adding the one field to the grid I want to run the query on (in this case email) and doing Shift-F2 to open the window and pasting your code in there and then running it. I may be doing something wrong but need to know what that is.<br />
<br />
Thanks,
</div>


<div>
Does your table have an autonumber field named ID?
</div>


<div>
aikimark,<br />
<br />
Yes, my table does have an autonumber field called ID, the program created it when it made the table. Thanks.
</div>


<div>
I repeated the same error in the 2nd query that was originally there, but only in the GROUP BY clause<br />
<br />
SELECT DISTINCT &nbsp;FName, LName, Email FROM yourTable<br />
<br />
or<br />
<br />
SELECT &nbsp;FName, LName, Email<br />
FROM yourTable<br />
GROUP BY &nbsp;FName, LName, Email
</div>


Duplicates-Checking-queries.jpg

<div>
This query solved what I was looking for and correctly picked the fields where I was looking for duplicates.
</div>


<div>
<div class="content wysiwyg-content">
In Access 2010, I have a query based on a table that has fields for FName, LName, Company, and Email. Some of the records have the same FName, LName and Email. for these records, just focusing on the Email field, I want to create a query that will only give me a record where the email is unique, so I want to get rid of the records that have duplicate fields.<br />
<br />
Thanks,
</div>
</div>


In Access 2010, I have a query based on a table that has fields for FName, LName, Company, and Email. Some of the records have the same FName, LName and Email. for these records, just focusing on the Email field, I want to create a query that will only give me a record where the email is unique, so I want to get rid of the records that have duplicate fields.

Thanks,

Finding a unique value in Access 2010 query

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.