update based on column name dynamic

  • Thread starter Thread starter Brian
  • Start date Start date
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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - retrieve data on last create named range from previous inserted named range 0
Checking if data exists another table and, if yes, extracting a value 0
Recordset not updateable 3
Query - auto fill "between values"? 3
Can run update query programmatically in windows 7 1
Dynamic Controls on a Report 5
update query 5
Question on Query Comparing 2 values 2

Back
Top