Return Min & Max variables.

Hi,

After pulling a collection of scores from a DB, I am trying to display the MIN and MAX of the numbers being returned as well as all the other corresponding information.

I have been trying to do this inside of my loop.

I know this is a simple procedure however I am unable to figure it out.

Thanks

Use SQL;

Code:

---


SELECT Min(ScoreFieldName) As MinimumScore FROM Table

SELECT Max(ScoreFieldName) As MaximumScore FROM Table

---

Or inside of loop

Code:

---


Dim minScrore, maxScore

...open recordset...


do unitl rs.eof
  if minScore > rs("ScoreField") then minScore=rs("ScoreField")
  if maxScore < rs("ScoreField") then maxScore=rs("ScoreField")
  rs.movenext
loop

---