'看来你确实有点菜'引用Micrsoft Active Data Object 2.6 Library,下面代码放到窗体的Load事件里Set Rs = New ADODB.Recordset cnn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Persist Security Info=False;" & "Data Source = D:\RPC.mdb;" & _ "mode=ReadWrite" cnn.Open Rs.Open "select Sum(金额) As Price from 现金日记帐", cnntext1.text=rs!Price
漏了一个声明,应该如下:'引用Micrsoft Active Data Object 2.6 Library,下面代码放到窗体的Load事件里Dim conn As New ADODB.Connection Dim rs As New ADODB.Recordset cnn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Persist Security Info=False;" & "Data Source = D:\RPC.mdb;" & _ "mode=ReadWrite" cnn.Open rs.Open "select Sum(金额) As Price from 现金日记帐", cnntext1.text=rs!Price
rs.Open "select Sum(存货量) As Price from 进销存", cnn 如果我想得到的是sum(存货量*进价)即库存成本,该如何表达呢?在线等能人解答!
text1.text=text1.text & rs("金额").value
rs.movenext
loop
text1.text=Val(text1.text) + rs("金额").value
rs.movenext
loop
rs.open "select Sum(金额) As Price from 现金日记帐",Con
Me.text1=rs!Price
LZ数据库字段最好不要用汉字 别扭
请写完整的代码谢谢.需要用到控件请写出控件名称
cnn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Persist Security Info=False;" & "Data Source = D:\RPC.mdb;" & _
"mode=ReadWrite"
cnn.Open
Rs.Open "select Sum(金额) As Price from 现金日记帐", cnntext1.text=rs!Price
Dim rs As New ADODB.Recordset
cnn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Persist Security Info=False;" & "Data Source = D:\RPC.mdb;" & _
"mode=ReadWrite"
cnn.Open
rs.Open "select Sum(金额) As Price from 现金日记帐", cnntext1.text=rs!Price
如果我想得到的是sum(存货量*进价)即库存成本,该如何表达呢?在线等能人解答!