<div>
A little more detail would be helpful? &nbsp;This isn't a homework assignment, is it?<br />
<br />
Are you trying to identify only those records in a table which are unique for one or more fields, or are you simply trying to return a set of records with unique values. &nbsp;If the latter, you can use the DISTINCT predicate in your SELECT statement:<br />
<br />
SELECT DISTINCT Field1, Field2 FROM your Table<br />
<br />
Or you might want to use a GROUP By clause:<br />
<br />
SELECT Field1, Field2 FROM yourTable GROUP By Field1, Field2
</div>


<div>
No it is not hw. but I am new to ACCESS. I need to eliminate Identical rows<br />
<br />
Ex.<br />
<br />
1 &nbsp;2 3<br />
1 2 &nbsp;3<br />
3 4 5<br />
<br />
i just want my result set as<br />
1 2 3<br />
3 4 5
</div>


<div>
As Dale mentioned, more detail is helpful. <br />
<br />
Are those values in the SAME field, or in DIFFERENT fields? How you go about showing distinct records depends greatly on that.<br />
<br />
Also, you mention you want to &quot;eliminate&quot; identical rows. Does that mean you want to remove them, or just not show them in your query?<br />
<br />
Note that Access includes a &quot;Find Duplicates Query Wizard&quot; which may be helpful. to use that, click the Create tab, and select &quot;Query Wizard&quot;. You'll see the Duplicates Query in that list. Select that, and follow the prompts.
</div>


<div>
Dale/Scott<br />
I have attached the sample table as an image. I want to eliminate Row 3 ( 2 A B C).<br />
<br />
ROW 1 is the fieldnames in my table.<br />
<a href="https://filedb.experts-exchange.com/incoming/2014/12_w50/887336/TABLEIMAGE.JPG" target="_blank" title="TABLEIMAGE.JPG (26 KB)"><img alt="TABLEIMAGE.JPG" class="file-block lazyload" style="max-width: 518px;" data-src="https://filedb.experts-exchange.com/incoming/2014/12_w50/887336/TABLEIMAGE.JPG" /></a><br />
Thanks,<br />
LAKSHMI
</div>


TABLEIMAGE.JPG

<div>
<div class="content wysiwyg-content">
How to find Unique Records in ACCESS
</div>
</div>


ACCESS

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.