<div>
take a look at the max function. Also look at dmax.
</div>


take a look at the max function. Also look at dmax.

<div>
Using DMax:<br />
Dim MaxVal as variant<br />
<br />
MaxVal = DMax(&quot;YourField&quot;, &quot;YourTable&quot;)
</div>


Using DMax:
Dim MaxVal as variant

MaxVal = DMax("YourField", "YourTable")

<div>
Are really talking about a &quot;DataSet&quot; &nbsp;i.e. a .NET object?<br />
<br />
If so, then the following will do the trick<br />
<br />
dsMyDataSet.tables(&quot;MyTabl<wbr />e&quot;).Defaul<wbr />tView.Sort<wbr /> = &quot;MyField&quot;<br />
dim dr as datarow = dsMyDataSet.Tables(&quot;MyTabl<wbr />e&quot;).DataVi<wbr />ew.Rows(0)<wbr /><br />
<br />

</div>


Are really talking about a "DataSet"  i.e. a .NET object?

If so, then the following will do the trick

dsMyDataSet.tables("MyTable").DefaultView.Sort = "MyField"
dim dr as datarow = dsMyDataSet.Tables("MyTable").DataView.Rows(0)



<div>
Not sure I understand why you would choose to use 6 lines of code and overhead when you can do the same thing with 1 line of code. &nbsp;That's very inefficient.
</div>


Not sure I understand why you would choose to use 6 lines of code and overhead when you can do the same thing with 1 line of code.  That's very inefficient.

<div>
Arji,<br />
<br />
I think it was accepted, because it was a complete example.<br />
<br />
Im just here to help, if you want the points thats fine with me.
</div>


Arji,

I think it was accepted, because it was a complete example.

Im just here to help, if you want the points thats fine with me.

<div>
Don't care about the points....just thought it was a little strange. &nbsp;It is the asker's right to choose whatever answer he wants especially since you answered first and it WAS a correct answer. &nbsp;I would only object if my answer was first and correct and the asker chose something submitted after my answer....no problem...just curious.
</div>


Don't care about the points....just thought it was a little strange.  It is the asker's right to choose whatever answer he wants especially since you answered first and it WAS a correct answer.  I would only object if my answer was first and correct and the asker chose something submitted after my answer....no problem...just curious.

<div>
<div class="content wysiwyg-content">
How do I search through a Microsoft Access Dataset using VBA to find the greatest value
</div>
</div>


How do I search through a Microsoft Access Dataset using VBA to find the greatest value

Searching to a Microsoft Access Dataset using VBA

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.