Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Finding max value of a field

Status
Not open for further replies.

kevink

Programmer
Nov 23, 1999
53
IE
Any ideas on how I can go about finding the max value of a file that contains unsorted numbers? I can do it through ASP but don't know how to get the code into Access (2000/97)!!<br>
<br>
Thanks,<br>
<br>
Kevin.
 
Assuming that your &quot;file&quot; is a database table, use the following SQL:<br>
<br>
SELECT Max(field) AS MaxValue FROM table<br>
<br>
<br>

 
In general, an easy way to figure out Access SQL is to use a wizard to build an Access query and then go view the SQL version of it in the Query Window. If you right-click on any Access query while in the design window, you can see a list of options such as &quot;top values&quot; (max).
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top