Need to Get Value of Aliased Column's Underlying Equation in DAO/ADO

[james.igoe]

I am looping through the QueryDef object to get the name of the query,
the name of the field, and I want to get the value of the underlying
equation for the column as well.

In this case, the underlying value is often a self-programmed
function, or an equation using values in joined tables. I need to get
the values from the underlying equations.

I've reviewed all the values of the QueryDef.Fields object and cannot
find a property that will give me the underlying value.

Is it possible with DAO or ADO?

 

[Douglas J. Steele]

I think the only way would be to actually parse the SQL.

 

[dbahooker]

I believe that you could do this same thnig; using SQL Server and
Access Data Projects-- and you could get the simple calculation for
the FIELD via looking into syscomments