问题1:
------------------------------------------
我想计算数据库中某字段的所有值的和(如:将全部收入汇总,请问语句怎么写法呢?)问题2:
------------------------------------------
我建两个表(表1有上面全部收入汇总得出的总值)(表2是我支出的所有汇总值)然后相减得到余额怎么写法呢?问题3:
=-----------------------------------------
我用两个dtpicker查询两个月份之间的支出额又怎么写法?先谢.
------------------------------------------
我想计算数据库中某字段的所有值的和(如:将全部收入汇总,请问语句怎么写法呢?)问题2:
------------------------------------------
我建两个表(表1有上面全部收入汇总得出的总值)(表2是我支出的所有汇总值)然后相减得到余额怎么写法呢?问题3:
=-----------------------------------------
我用两个dtpicker查询两个月份之间的支出额又怎么写法?先谢.
"select sum(a) from 表 where date between#" dtpicker1.value "# and#" dtpicker2.value#"sqlserver
"select sum(a) from 表 where date between'" dtpicker1.value "' and'" dtpicker2.value'"
select sum(a) from 表1
select sum(b) from 表 2dim c as double
c=a-b
如果我用text1.text来显示sum(a)的结果我怎么样做呢?
text1.text=rs.fields("a").value
2、"select sum(table1.a)-sum(table2.b) as 余额 from table1,table2"
3、"select sum(a) from table1 where date between '" & dtpicker1.value &"' and '" & dtpicker2.value & "'"
-----------------------------
abc = "select sum(金额) from 支出 where 时间 between #" & DTPicker3.Value & "# and #" & DTPicker4.Value & "#"
If abc <> "" Then
Adodc2.RecordSource = abc
Text1.Text = Adodc2.RecordSource
Else
Adodc2.RecordSource = "select * from 支出 order by id"
End If
Adodc2.Refresh
If Adodc2.Recordset.RecordCount = 0 Then
i = MsgBox("没有符合条件的记录", vbOKOnly + vbInformation, "提示")
End If
---------------------------------
请指教谢谢
Text1.Text = str(Rst.Fields(0).value)
2. Rst.Open "Select SUM(T1.InMoney) - SUM(T2.OUTMoney) From Table1,Table2",cnt
Text1.Text = str(Rst.Fields(0).value)
3. Rst.Open "Select SUM(OUTMoney) From Table2 where OUTDate Between " & DTPicker1.Value & " And " & DTPicker2.Value,cnt
Text1.Text = str(Rst.Fields(0).value)
和asp一齐搞到头到昏了.
如果我用text1.text来显示sum(a)的结果我怎么样做呢?