Break up those long SQL statements

[admin]

Does you SQL statement look like this...

SQL = "Select FName, LName, Address, City, State, Zip From tblCustomers Where Zip Between '77437' And '90210'"

Here's two ways to break them up so that they're more readable:

SQL = "Select FName, LName, Address, State, Zip "
SQL = SQL & "From tblCustomers "
SQL = SQL & "Where Zip Between '77437' And '90210'"

and

SQL = "Select FName, LName, Address, State, Zip" _
& " From tblCustomers" _
& " Where Zip Between '77437' And '90210'"

With the second method, note that there is a space between the last letter and the _ symbol.