Hi;

Is it possible in MS Access to create an update query where the field being updated is determined at the time the query is run? For example...

Code:
update myTable set [someField] = 'ABC';
In this example I would like to use a lookup table to set the field name (someField) used in the query.

Is this possible?

Thanks
Lin