This seem easy I can not make to work please help. How to break this into several line of code?

sqlString = "SELECT DISTINCTROW PHARM_INSURED_OFFLINE.ALTERNATE_ID, PHARM_INSURED_OFFLINE.LAST_NAME, PHARM_INSURED_OFFLINE.FIRST_NAME, PHARM_INSURED_OFFLINE.ADDRESS1, PHARM_INSURED_OFFLINE.ADDRESS2, PHARM_INSURED_OFFLINE.DIVISION, PHARM_INSURED_OFFLINE.LOCATION, PHARM_INSURED_ONLINE.GROUP_KEY, PHARM_INSURED_ONLINE.PERSON_CODE, PHARM_INSURED_ONLINE.EFFECTIVE_DATE, PHARM_INSURED_ONLINE.BIRTH_DATE, PHARM_INSURED_ONLINE.TERMINATION_DATE"


All this line are suppose to be a single line. But I want them in different line using underscore but it seem that I am not getting it right.

You need to insert an underscore at the end of each line to continue the lines and some &'s (or +'s, if you prefer to connect strings that way) to connect the strings, like this:

sqlString = "SELECT DISTINCTROW PHARM_INSURED_OFFLINE.ALTERNATE_ID," & _
    "PHARM_INSURED_OFFLINE.LAST_NAME, PHARM_INSURED_OFFLINE.FIRST_NAME," & _
    "PHARM_INSURED_OFFLINE.ADDRESS1, PHARM_INSURED_OFFLINE.ADDRESS2," & _
    "PHARM_INSURED_OFFLINE.DIVISION, PHARM_INSURED_OFFLINE.LOCATION," & _
    "PHARM_INSURED_ONLINE.GROUP_KEY, PHARM_INSURED_ONLINE.PERSON_CODE," & _
    "PHARM_INSURED_ONLINE.EFFECTIVE_DATE, PHARM_INSURED_ONLINE.BIRTH_DATE," & _
    "PHARM_INSURED_ONLINE.TERMINATION_DATE"

(Notice that there is a space between the & and the _. If you position the underscore up against the & at the end of each line, you'll get errors.)

Hope that solves your problem.