Finding max value of a field

[kevink]

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.

 

[bitbrain]

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>

 

[elizabeth]

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).