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

  • Thread starter Thread starter james.igoe
  • Start date Start date
J

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?
 
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
 
Back
Top