title: How to Find 2nd Highest/Lowest Value Across Fields of Record in Access
body: <p>I found functions to get the Highest and Lowest values in the link below.. </p>
  
  <p><a href="http://support.microsoft.com/kb/209857?wa=wsignin1.0" rel="nofollow">http://support.microsoft.com/kb/209857?wa=wsignin1.0</a></p>
  
  <p>Now I just need to get the second highest/lowest values as well for a function. How can I reference those values? .. If it helps there are only 3 fields I am comparing. The value in the field that isn't referenced by either Minimum or Maximum is the one I need to reference, however someway of specifying 2nd highest/lowest would be ideal.  </p>
  
  <p>Thanks!</p>