update based on column name dynamic

B

Brian

is there a way that I can update a column where the column equals a
value retrived by a recordset.. for example

I have a table
COLUMNS
DBH 1 4 7

then the recordset produces a value that is 7 so I need to update the 7
column of the table with a different value also in the recordset

many thanx
 
K

KARL DEWEY

then the recordset produces a value that is 7 so I need to update the 7
column of the table with a different value also in the recordset
I do not follow this.
What "produces a value that is 7?"
Do you mean that you need to change the name of column 7 or change the data
in that field?

Post a few records that has your typical data and then state what you want
to happen.
 
Top