VB 代码换行~~

Question

Set rs = cnn.Execute("SELECT  '1生鲜',SUM(XSSR      + PFSR ) XSSR, SUM(XSSR+PFSR)-SUM(XSHSJJJE+PFHSJJJE+XSHSJJAD+PFHSJJAD)+SUM(XSSUPZK   + PFSUPZK) ML_SUP FROM  SALECOSTDAY 。。
后面还有，想分成两句写怎么实现呢？

Answer 1

Set rs = cnn.Execute("SELECT  '1生鲜',SUM(XSSR      + PFSR ) XSSR, " & _
                     " SUM(XSSR+PFSR)-SUM(XSHSJJJE+PFHSJJJE+XSHSJJAD+PFHSJJAD)+SUM(XSSUPZK   + PFSUPZK) " & _
" ML_SUP FROM  SALECOSTDAY...."

Answer 2

代码转行,楼上正解.字符换行,& vbTab

Answer 3

Set rs = cnn.Execute("SELECT  '1生鲜',SUM(XSSR      + PFSR ) XSSR, " & _
                     " SUM(XSSR+PFSR)-SUM(XSHSJJJE+PFHSJJJE+XSHSJJAD+PFHSJJAD)+SUM(XSSUPZK   + PFSUPZK) " & _
" ML_SUP FROM  SALECOSTDAY...."