Recordset Order By

[DMT Dave]

Hi Guys, is there a way i can order a recordset ordering 2 fields ?, i want to order DelTo Ascending And ShipmentDate Descending ??? much appreciate

Set rs2 = CurrentDb.OpenRecordset("SELECT tblEdit.DelTo, tblEdit.ShipmentDate, tblEdit.Town, tblEdit.SONumber, tblEdit.PONumber, tblEdit.ItemType, tblEdit.ItemNo, tblEdit.Status FROM tblEdit WHERE Customer = '" & Cust & "'" & " And Status = '" & MyStatus & "'" & " Or Status = '" & MyStatus2 & "'" & " Or Status = '" & MyStatus3 & "'" & " And Source = '" & Src & "' ORDER BY DelTo;")

[June7]

ORDER BY DelTo, ShipmentDate DESC

[ranman256]

very easy to do in a query.