Hello,
Right now I have code that successfully inserts one table into another.
I would like to be able to change the values in one column on the final merged table.
In the final table1, if the value under the column 'section' is "full", I would like it to be changed to "skip." If the value is "skip," I would like it to be changed to "full"... for the entire table1.
Is that possible?
Any ideas?
Thanks, (-:
Brian
Right now I have code that successfully inserts one table into another.
I would like to be able to change the values in one column on the final merged table.
Code:
strsql$ = "INSERT INTO table1 SELECT table2.* FROM table2;"
db.Execute strsql$
In the final table1, if the value under the column 'section' is "full", I would like it to be changed to "skip." If the value is "skip," I would like it to be changed to "full"... for the entire table1.
Is that possible?
Any ideas?
Thanks, (-:
Brian