Search results for query: *

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

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

Great! It worked! Thanks, (-: Brian

...an ID field... does that make a difference? Any suggestions? For dist = 1 To 28 If checkMerge(dist).Value = 1 Then strsql$ = "INSERT INTO table1 SELECT table2.* FROM table2 WHERE section = " & namearray(dist) & ";" db.Execute strsql$ End If Next dist Thanks, (-...

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

...one table into another. However, I would like to only select a certain ID from that table. Here is what I have now: strsql$ = "INSERT INTO table1 SELECT table2.* FROM table2;" db.Execute strsql$ How can I modify this statement to only select a certain ID from the table? Thanks, (-...

It worked! Thank you all very much! Thanks, (-: Brian

Thanks for all your help. Hang in there with me... I am receiving an Internal Script Error on the page. It says it is expecting a ')' at character 63. Am I correct in saying that I do not need to change _myURL to anything when I implement the code? I just copy the script just as it is in...

Jeff- Yes, I understand where this code would go, however I'm still unsure about one item, please bear with me: What do I replace with the _myURL in the java script, and does it need to be in quotes? Is it the URL of the current page? Thanks, (-: Brian

Jeff- Thank you very much for your reply. My webpage has several different links pointing to different destinations, and so is there a way I could make this work for multiple destinations? It appears this would only work for a page with a single link for which I would like this message to...