Change values while inserting table? 2

[briglass]

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.

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

 

[briglass]

It worked!!

Thanks a lot!

Thanks, (-:
Brian

 

[Golom]

Log" may also be reserved. Use [Log] instead.