Sorting data in ADO Recordset

[martinjamesward]

I am trying to calculate time between failures on a large dataset of repairs.



I am attempting to pull in the data from a query into an ADO recordset, sort the recordset and then step through the recordset, processing as I go. However every time I process the data the sort does not work.

My VBA for calling the data an sorting the data is below, can anyone tell me what I am doing wrong

Dim rstAllRepairs As Recordset
Set rstAllRepairs = CurrentDb.OpenRecordset"qry_RepairsOrderedForMTBFCalculations")
 
rstAllRepairs.Sort = "rpr_JobNumber DESC, rpr_Model DESC,rpr_SerialNumber DESC"

[dcrake]

Is your recordset not aready sorted in the query itself? If you specify the sort order in the report it should cascade through to the recordset.

David