I am trying to write a query with a large amount of fields and need it to write on multiple lines. Any suggestions?
rsRecordset.Open _
Source:="Select MASS_TEMP_INPUT.LIC_ACTION_CD, MASS_TEMP_INPUT.[LIC-ID], MASS_TEMP_INPUT.[LIC-SYS-ASSGN-NBR], MASS_TEMP_INPUT.[LIC-ST-CS], MASS_TEMP_INPUT.[LIC-NBR], " _
& "MASS_TEMP_INPUT.[LIC-CLASS-CD], MASS_TEMP_INPUT.[LIC-SAN-TY-CD], MASS_TEMP_INPUT.[LIC-EFF-DT], MASS_TEMP_INPUT.[LIC-RES-IND], MASS_TEMP_INPUT.[LIC-ISS-DT], " _
& "MASS_TEMP_INPUT.[LIC-EXPR-DT], MASS_TEMP_INPUT.[LIC-ST-STTS-CD], MASS_TEMP_INPUT.[LIC-HUM-STTS-CD], MASS_TEMP_INPUT.[LIC-HUM-STTS-REAS-CD], " _
& "MASS_TEMP_INPUT.[LIC-TERM-PEND-DT], MASS_TEMP_INPUT.[LIC-TERM-DT], MASS_TEMP_INPUT.[LIC-LST-CHG-USER-ID], MASS_TEMP_INPUT.[LIC-HUM-STTS-CHG-DT], " & _
"MASS_TEMP_INPUT.[LIC-DBA-TAX-NBR], MASS_TEMP_INPUT.[LIC-DBA-NM], MASS_TEMP_INPUT.[LIC-TERM-FOR-CAUS], MASS_TEMP_INPUT.[LIC-FIRST-TM-IND]" _
" From MASS_TEMP_INPUT;", _
ActiveConnection:=CurrentProject.Connection
rsRecordset.Open _
Source:="Select MASS_TEMP_INPUT.LIC_ACTION_CD, MASS_TEMP_INPUT.[LIC-ID], MASS_TEMP_INPUT.[LIC-SYS-ASSGN-NBR], MASS_TEMP_INPUT.[LIC-ST-CS], MASS_TEMP_INPUT.[LIC-NBR], " _
& "MASS_TEMP_INPUT.[LIC-CLASS-CD], MASS_TEMP_INPUT.[LIC-SAN-TY-CD], MASS_TEMP_INPUT.[LIC-EFF-DT], MASS_TEMP_INPUT.[LIC-RES-IND], MASS_TEMP_INPUT.[LIC-ISS-DT], " _
& "MASS_TEMP_INPUT.[LIC-EXPR-DT], MASS_TEMP_INPUT.[LIC-ST-STTS-CD], MASS_TEMP_INPUT.[LIC-HUM-STTS-CD], MASS_TEMP_INPUT.[LIC-HUM-STTS-REAS-CD], " _
& "MASS_TEMP_INPUT.[LIC-TERM-PEND-DT], MASS_TEMP_INPUT.[LIC-TERM-DT], MASS_TEMP_INPUT.[LIC-LST-CHG-USER-ID], MASS_TEMP_INPUT.[LIC-HUM-STTS-CHG-DT], " & _
"MASS_TEMP_INPUT.[LIC-DBA-TAX-NBR], MASS_TEMP_INPUT.[LIC-DBA-NM], MASS_TEMP_INPUT.[LIC-TERM-FOR-CAUS], MASS_TEMP_INPUT.[LIC-FIRST-TM-IND]" _
" From MASS_TEMP_INPUT;", _
ActiveConnection:=CurrentProject.Connection