<div>
select id, name, max(current) as maxcurrent<br />
from tblname<br />
group by id, name
</div>


select id, name, max(current) as maxcurrent
from tblname
group by id, name

<div>
<div class="content wysiwyg-content">
I am trying to find the max value in the Current column using ms access.<br />
Table<br />
ID &nbsp; &nbsp;Name &nbsp; &nbsp;Current<br />
1 &nbsp; &nbsp; &nbsp;A &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1 <br />
1 &nbsp; &nbsp; &nbsp;B &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 23<br />
1 &nbsp; &nbsp; &nbsp;C &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 12 &nbsp;<br />
2 &nbsp; &nbsp; &nbsp;A &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;22<br />
2 &nbsp; &nbsp; &nbsp;B &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;9<br />
<br />
So my end result with be the following:<br />
ID &nbsp;Name Current<br />
1 &nbsp; &nbsp;B &nbsp; &nbsp; &nbsp; &nbsp;23<br />
2 &nbsp; &nbsp;A &nbsp; &nbsp; &nbsp; &nbsp;22
</div>
</div>


I am trying to find the max value in the Current column using ms access.
Table
ID    Name    Current
1      A           1 
1      B           23
1      C           12  
2      A            22
2      B            9

So my end result with be the following:
ID  Name Current
1    B        23
2    A        22

Find Max Value MS Access 2003

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

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.