<div>
If the value in Company Name is exactly the same (and is the field where you want to find the values that have no Duplicates:<br />
<br />
SELECT [Company Name], COUNT([Company Name] AS NameCnt FROM YourTable GROUP BY [Company Name] HAVING COUNT([Company Name])=1
</div>


If the value in Company Name is exactly the same (and is the field where you want to find the values that have no Duplicates:

SELECT [Company Name], COUNT([Company Name] AS NameCnt FROM YourTable GROUP BY [Company Name] HAVING COUNT([Company Name])=1

<div>
<div class="content wysiwyg-content">
I have an Excel file that looks like the following. &nbsp;I know how to use the query wizard to find dupe Company Names and how to use the query wizard to find Dupe First Names. &nbsp;But how do I create a query to find records that have no dupes? &nbsp;In this case, just one record.<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2017/07_w29/1183093/Dupes.bmp" target="_blank" title="Dupes Example (723 KB)"><img alt="Dupes Example" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2017/07_w29/800_1183093/Dupes.bmp" /></a>
</div>
</div>


Dupes.bmp

I have an Excel file that looks like the following.  I know how to use the query wizard to find dupe Company Names and how to use the query wizard to find Dupe First Names.  But how do I create a query to find records that have no dupes?  In this case, just one record.



How find records with no dupes

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.