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.
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 "top values" (max).
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.