Reconstruction SQL Statements

When you copy a SQL string from the SQL window to a module window, it's usually in block form instead of being one long statement, which VBA requires. Consequently, you have to assemble all the clauses on one line, and doing so can produce an Expected Case error, which you must clear before you can continue. You can easily avoid this error by reconstructing your statement from the bottom up. In other words, if the SQL statement comprises three separate lines, don't pull the second line around to the first and then pull the third line around to the first. Instead, pull up the third line to the second, and then pull up the combined second line to the first line.

Access Index

Main Index