ADODB query in form

[dbero]

I am trying to open an ADODB recordset in a form and order by two elements, but it won't let me. It will order by one element, but not both. Any suggestion on how to modify the SQL in the form to sort by ARP ID first, then begindate?

Dim OpenLegStatSeq As ADODB.Recordset
Set OpenLegStatSeq = New ADODB.Recordset
OpenLegStatSeq.Open "SELECT * from LegalStatSeq ORDER BY LegalStatSeq.[ARP ID], LegalStatSeq.begindate asc;", CurrentProject.Connection, adOpenKeyset, adLockOptimistic

 

[Andrzejek]

If you run your Select statement in Access:
[tt]
SELECT *
from LegalStatSeq
ORDER BY [ARP ID], begindate
[/tt]
Do you get the records in the right order?
Is the field [tt]begindate[/tt] defined as Date?

Have fun.

---- Andy