<div>
I cannot imagine why this would bring back more than one record, as you generally don't repeat ID values, and:<br />
<br />
SELECT Max([ID]) from tblCustomers<br />
<br />
would only return a single ID value.<br />
<br />
Can you describe (in words, not SQL) what it is you really want to accomplish? &nbsp;<br />
<br />
You may have to provide &nbsp;a little more detail about your table structure. &nbsp;If you could provide a couple of sample records (sanitized to avoid revealing personal, financial, or proprietary information) , that would be even better.
</div>


I cannot imagine why this would bring back more than one record, as you generally don't repeat ID values, and:

SELECT Max([ID]) from tblCustomers

would only return a single ID value.

Can you describe (in words, not SQL) what it is you really want to accomplish?  

You may have to provide  a little more detail about your table structure.  If you could provide a couple of sample records (sanitized to avoid revealing personal, financial, or proprietary information) , that would be even better.

<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
I want to select all customer names from a table that share the highest ID. The following sql shows what I want to do but does not work.<br />
<br />
SELECT CustomerName FROM tblCustomers WHERE ID = MAX(ID)
</div>
</div>


Hi Experts,

I want to select all customer names from a table that share the highest ID. The following sql shows what I want to do but does not work.

SELECT CustomerName FROM tblCustomers WHERE ID = MAX(ID)

SQL query.

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.