Can someone please provide some direction...

Using ADO against Acccess 2000

I need the Recordset's rowID to be part of the recordset itself so that
I may use it as an ORDER BY subquery in an INNER JOIN.

I would think it would be something like this...
SQLStmnt = "SELECT CustomerMarket.AccountNumber, RowID FROM
CustomerMarket WHERE MarketName = ""FV"" ORDER BY ""QuantityTraded"""

Where RowID is some sort of recordset property or dB engin query.

Any ideas????

Thanks!!!

Trip