T
Trip
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
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