HOW SORT 2 recordset ?

[desprits]

What should I do to sort two recordset ?

Exemple:
First SORT by DateUtilisation
Second SORT by HresDebutUtilisation

This don't working:
adoTriTemps.Recordset.Sort = "DateUtilisation ASC" And "HresDebutUtilisation ASC"

 

[JAG14]

Probably better if you create a new recordset using an SQL statement from the first, try this...

[tt]

Sub SortByField()
Dim rstNewSorted as RecordSet
Dim SortDB as Database

Set SortDB = OpenDatabase("yourdb.mdb&quot 'Your Database Path

Set rstNewSorted = SortDB.OpenRecordSet("SELECT * " & _
"FROM YourTable ORDER BY " & _
"'DateUtilisation ASC', 'HresDebutUtilisation ASC'", _
dbOpenDynaset)

SortDB.Close
End Sub
[/tt]

Hope this helps.

[tt]"Very funny, Scotty... Now Beam down my clothes."[/tt]

 

[LostInCode]

adoTriTemps.Recordset.Sort = "DateUtilisation ASC, HresDebutUtilisation ASC"