<div>
How about this:<br />
<br />
SELECT Table1.Last AS LastName, First(Table1.First) AS FirstName<br />
FROM Table1<br />
GROUP BY Table1.Last;<br />
<br />
mx<br />

</div>


How about this:

SELECT Table1.Last AS LastName, First(Table1.First) AS FirstName
FROM Table1
GROUP BY Table1.Last;

mx


<div>
<div class="content wysiwyg-content">
I'm currently using the SQL query attached, but I believe this is giving me unique entire records. How can I modify this query to show me only unique records, but by lastname only. <br />
<br />
So if this exists in the table:<br />
<br />
lastname &nbsp; &nbsp;ss<br />
smith &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1212<br />
smith &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5412<br />
<br />
then I only want one smith to show up in the results.<br />
I'm using Access 2000<br />

<pre><code id="code-172383">SELECT DISTINCT FP.lastname, FP.ss
FROM FP
ORDER BY FP.lastname;
</code></pre>
</div>
</div>


I'm currently using the SQL query attached, but I believe this is giving me unique entire records. How can I modify this query to show me only unique records, but by lastname only. 

So if this exists in the table:

lastname    ss
smith           1212
smith           5412

then I only want one smith to show up in the results.
I'm using Access 2000

Select unique field values

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.

Microsoft Access

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.