Sorting recordsets

• • Reply

  19 years ago

  by mza

  Malek

  London, Ontario, United Kingdom

  Joined 19 years ago

  I know this is simple and I've done it before but it's been a while and I can't remember how to do it...
  I've connected various fields (text boxes) to MS Access, so I'm reading MS Access records using a data control, and now I'm trying to sort the records that have been read in ascending/descending order. Can anyone tell me what the syntax for it is?
  

  
  "datBusiness.Recordset.Sort" doesn't quite do the job. There's something missing and you know how descriptive and helpful Microsoft's MSDN help is...
  

  
  Thanks in advance.

  Report abuse
• • Reply

  19 years ago

  by James Crowley

  James Crowley

  London, United Kingdom

  Joined 20 years ago

  Can't you just use an SQL Statement with an Order By clause?

  Report abuse
• • Reply

  19 years ago

  by mza

  Malek

  London, Ontario, United Kingdom

  Joined 19 years ago

  I know that's another way of doing it, but I have difficulty using SQL and I don't know how to append SQL code into my VB code.

  Report abuse