长SQL语句怎么转行

843151504　发表于：2009-06-17 18:51:22 　

Me.核对本库子.Form.RecordSource = "SELECT ""2009累计"" AS 年月, Sum(多栏式汇总.金额合计) AS 金额合计, Sum(多栏式汇总.工资、薪金) AS 工资、薪金, Sum(多栏式汇总.福利费) AS 福利费, Sum(多栏式汇总.折旧费) AS 折旧费, Sum(多栏式汇总.办公费) AS 办公费, Sum(多栏式汇总.电话费) AS 电话费, Sum(多栏式汇总.差旅费) AS 差旅费, Sum(多栏式汇总.业务费) AS 业务费, Sum(多栏式汇总.其它) AS 其它, Sum(多栏式汇总.水电费) AS 水电费, Sum(多栏式汇总.利息支出) AS 利息支出 FROM 多栏式汇总"

上述语句,我用下划线截短转行就错误,应怎么截短转行?

Top

点燃一支烟发表于：2009-06-17 18:57:13

Me.核对本库子.Form.RecordSource = "SELECT ""2009累计"" AS 年月, Sum(多栏式汇总.金额合计) AS 金额合计, " & _
"Sum(多栏式汇总.工资、薪金) AS 工资、薪金, Sum(多栏式汇总.福利费) AS 福利费, Sum(多栏式汇总.折旧费) AS 折旧费, " & _
"Sum(多栏式汇总.办公费) AS 办公费, Sum(多栏式汇总.电话费) AS 电话费, Sum(多栏式汇总.差旅费) AS 差旅费, " & _
"Sum(多栏式汇总.业务费) AS 业务费, Sum(多栏式汇总.其它) AS 其它, Sum(多栏式汇总.水电费) AS 水电费," & _
"Sum(多栏式汇总.利息支出) AS 利息支出 FROM 多栏式汇总"

Top

843151504 发表于：2009-06-17 20:28:01

原来要加连接号呀,气死我了

Top

总记录：2篇页次：1/1 9 1 :

Access交流中心

长SQL语句怎么转行