Create a query with the desired field (Salary) sorted in decenditg order.
In the query properties, find the "top Values" line and enter 2.
Wherever you use/need the value, open the query as a recordset and do rst.movelast and read/use the information (fields) .
(The LAST record in the query (there will only be 2) is the one you want.) [sig]<p>MichaelRed<br><a href=mailto:mred@duvallgroup.com>mred@duvallgroup.com</a><br>There is never time to do it right but there is always time to do it over[/sig]
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.