Q: Get query text for field

M

MarkD

Using Access 2000.

Hey all,

Say I have a query QRY_NAMES: "Select Name, MAX(TRANS_DT)
LASTRANS from TABLE1 group by NAME"

I created a querydef pointing to that query and stepping
through the fields.
fld(0).name = NAME
fld(1).name = LASTRANS

Is there a way to return the SQL text behind the LASTRANS
field, ie fld(1).someproperty = "MAX(TRANS_DT)"

??

Thanks
-Mark
 
Top