E
Ed Boulineau
Guest
Is it possible to internally develope the Name of a Field within a Query and use that Name to obtain the value contained in the field with that Name?
Hypothetical Example:
fieldname="Lv"&[xx] where [xx] value can be "01" thru "99"
Actual Field Names and Values in the table are:
Names: Lv01, Lv02, Lv03,..... Lv99
Values: ABC DEF GHI ZYX
For [xx] with value of "03" the Field Name would be Lv03
and the Value obtained should be "GHI".
I realize that this might require some modification in the SQL.
Hypothetical Example:
fieldname="Lv"&[xx] where [xx] value can be "01" thru "99"
Actual Field Names and Values in the table are:
Names: Lv01, Lv02, Lv03,..... Lv99
Values: ABC DEF GHI ZYX
For [xx] with value of "03" the Field Name would be Lv03
and the Value obtained should be "GHI".
I realize that this might require some modification in the SQL.