order a rs

Results 1 to 3 of 3

Thread: order a rs

  1. #1
    Join Date
    Dec 1969

    Default order a rs

    how to order a record set falling

  2. #2
    keithadler@hotmail.com Guest

    Default RE: order a rs

    The recordset object supports a Sort method under most conditions.<BR><BR>The syntax is:<BR><BR>rstRecords.Sort="Field1 ASC"<BR><BR>Or<BR><BR>rstRecords.Sort="Field1 ASC, Field2 DESC"<BR><BR>... and so forth.<BR><BR>

  3. #3
    keithadler@hotmail.com Guest

    Default RE: order a rs

    You could also use:<BR><BR>SELECT * FROM Table ORDER BY Field1<BR><BR>Or<BR><BR>SELECT * FROM Table ORDER BY Field1, Field2<BR><BR>Or<BR><BR>SELECT * FROM Table ORDER BY Field1 DESC, Field2 ASC<BR><BR>... and so forth.<BR><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