Recent content by briglass

It worked!! Thanks a lot! Thanks, (-: Brian

:( Even this gives me a syntax error: "UPDATE log SET section = IIF (section = 'FULL', 'SKIP', 'FULL') Thanks, (-: Brian

Either way, I still get a "syntax error in the UDATE statement" ... Any ideas? Thanks, (-: Brian

Oops... I have one more question... What if there are 2 cases where I don't want to switch this... and that case is if the value in the column "area" is "DIS0" or "DISX"... Will this add much complexity? Thanks, (-: Brian

And these are all single quotes, right? Thanks, (-: Brian

wait, wait: sql$ = "UPDATE Table1 SET Section = IIF ( section = "FULL" or section = "SCREEN", "SKIP", IIF ( section = "SKIP", "FULL", section ))" Thanks, (-: Brian

Ok, cool. Now let me see if I have it right: sql$= "Section = IIF ( section = "FULL" or section = "SCREEN", "SKIP", IIF ( section = "SKIP", "FULL", section )) Is that right? Thanks, (-: Brian

lespaul- Yes, thank you. What about if I had a third condition? I need all "screen" to be changed to "skip" as well. Thanks, (-: Brian

Thanks again! I see how it will work now. I'm a bit confused about the format, still. Should the SQL statement read: sql$= "UPDATE Table1 SET Section = IIF ( section = "FULL", "SKIP", IIF ( section = "SKIP", "FULL", section )" Thanks, (-: Brian

Thanks for the reply! Two questions: 1) Is that all to be as one SQL statement? 2) Won't that change everything to "Full" since it will change everything to "Skip" and then all "Skip" to "Full"? Thanks, (-: Brian

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...

Great! It worked! Thanks, (-: Brian

Hello, I am trying to merge table1 with table2, but only when the "section" column has a certain value. The statement worked fine until I added the last WHERE clause. I get the error "Too Few Parameters. Expected 1." The error explanation on the Microsoft website says, "you refer to a column...

That worked. Thank you very much! Thanks, (-: Brian

Thanks for your feedback! I seem to be having a problem with this solution. My final string looks like this: "INSERT INTO table1 SELECT table2.* FROM table2 WHERE ID = 01" However, I receive an error 3464: Data type mismatch in criteria expression. The line also does not work when I add a...