Hi everyone,
Recently I create a recordset based on a query. The code looks like this
:

Dim StrSQL as String
Dim Rst as ADODB.Recordset

StrSQL="SELECT (Quantity * UnitPrice) AS Total FROM Orders"
Rst.Open StrSQL

I want to dynamically filter the record based on the query above without
firstly knowing the name of the fields so that the query will look something
like this :

StrSQL="SELECT (Quantity * UnitPrice) AS Total FROM Orders WHERE (Quantity
* UnitPrice) > 1000".

Is there any recordset properties or any workaround at all that returns
the field expression (Quantity * UnitPrice), because if we use Rst.Fields(0).Name,
it returns 'Total' ?.


Thank you,




Setya