Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

max in recordset

Status
Not open for further replies.

darkwraith

Programmer
May 26, 2003
44
IT
Hi,
I can simplify my situation like this: I have a recordset made of integer numbers and I want to browse it to find the maximum value. How can I do that?
Thanks a lot,
Elena
 
Use an ORDER BY clause and then look at either the first or last record in the RecordSet


Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top