Recordset Query

Results 1 to 2 of 2

Thread: Recordset Query

  1. #1
    Join Date
    Dec 1969

    Default Recordset Query

    Hi..<BR>Can someone tell me how to find the maximum values in asp using recordset.<BR><BR>For eg: my ms access table has<BR>A B<BR>W1 - 10<BR>W2-20<BR>W3-10<BR>W4-80<BR>If I want to find the value of the maximum of all records using asp how do i do it. It should display the value of W4 that is 80, can you please e-mail me at

  2. #2
    Join Date
    Dec 1969

    Default RE: Recordset Query

    You could do...<BR><BR>strSQL = "SELECT MAX(fieldName) FROM tableName"<BR>Set rs = objConn.Execute(strSQL)<BR> <BR>Where objConn is your ADO connection to your db...<BR><BR>--Jason<BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts