Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004

    Question Unanswered: Order By sorts in VB6 with .mdb and SQL

    What i'm trying to accomplish is a secondary sort on another field.
    the .mdb has 3 fields, one of the fields is a DATE, the other two are FIRST and LAST

    1. sort by dates using SQL returning all the fields for 20 most recent records.

    this result is put into a recordset rstTemp. This part is working correctly.

    However, now i want to alpha sort on another field and put the 20 records in a recordset. How can this be done?

  2. #2
    Join Date
    Mar 2004
    Do you want to put the new results in a new recordset?

    Set Recordset2 = Recordset1.Clone

    Recordset2.Sort = "First"

    Download for FREE the ADO/DAO Data Controls that makes life EASIER developing database applications in: VB, FoxPro, Access, VC++, .NET etc... Navigate, Add New, Delete, Update, Search, Undo and Save your changes. Supports Disconnected Recordsets and Transactions!

    Or try our Ask An Expert service to answer any of your questions!

  3. #3
    Join Date
    May 2004
    Thank you very much!

Posting Permissions

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