Return Min & Max variables.

[jaymdouglas]

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

[andreys]

Use SQL;

SELECT Min(ScoreFieldName) As MinimumScore FROM Table

SELECT Max(ScoreFieldName) As MaximumScore FROM Table

Or inside of loop

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