SQL语句问题！

Question

'...
.Open "select sum(物料价值) as field1 from UseMaterial where 单据编号=" & "'" & ListView2.SelectedItem & "'", cnn_MainMsgBox rs_save.Fields("field1")

Answer 1

.Open "select sum(物料价值) from UseMaterial where 单据编号=" & "'" & ListView2.SelectedItem & "'", cnn_Main
改为
.Open "select sum(物料价值) as 物料价值 from UseMaterial where 单据编号=" & "'" & ListView2.SelectedItem & "'", cnn_Main

Answer 2

msgbox rs_save(0)msgbox rs_save.fields(0)msgbox rs_save.fields(0).value

Answer 3

upOpen "select sum(物料价值) as 物价之和 from UseMaterial where 单据编号=" & "'" & ListView2.SelectedItem & "'", cnn_Main