大家节日好！
我的表中，某一列N中存在几种相同字段比如：A、B、C，我想进行某一时段内同时进行A、B、C的分别统计查询。不知能否实现？如何写查询语句？请赐教，谢谢！以下是本人原来写的分别统计查询语句：
Dim sql As String
sql = "select * from 表 where N= '" & Trim(Combo1.Text) & "' and rq between #" & DTPicker1.Value & "# and #" & DTPicker2.Value & "# order by rq desc"
rs_feipin.CursorLocation = adUseClient
rs_feipin.open sql, conn, adOpenKeyset, adLockOptimistic
If Not rs_feipin.EOF Then
setgrid
setgridhead
displaygrid
If Combo1.Text = "A" Then
sum8 = 0
rs_feipin.MoveFirst
While Not rs_feipin.EOF
sum8 = sum8 + Val(rs_feipin.Fields(11).Value) ' A总量
rs_feipin.MoveNext
Wend
Text17.Text = Format(sum8, "##.0")
End If
If Combo1.Text = "B" Then
sum9 = 0
rs_feipin.MoveFirst
While Not rs_feipin.EOF
sum9 = sum9 + Val(rs_feipin.Fields(11).Value) 'B总量
rs_feipin.MoveNext
Wend
Text18.Text = Format(sum9, "##.0")
End If
If Combo1.Text = "C" Then
sum10 = 0
rs_feipin.MoveFirst
While Not rs_feipin.EOF
sum10 = sum10 + Val(rs_feipin.Fields(11).Value) 'C总量
rs_feipin.MoveNext
Wend
Text19.Text = Format(sum10, "##.0")
End If

[QUOTE]几种相同字段[/QUOTE]
怎么理解？

楼上：几种相同字段的意思，就是N列中有若干个A和B和C，把同是A的进行求和，依次B、C也是进行同类求和。例如如下：形式

rq N H
2007-01-02 A 15
2007-02-02 A 100
2007-02-15 B 110
2007-02-18 C 12
2007-02-19 B 150
2007-02-20 C 100

SELECT N, SUM(H) FROM 表名 GROUP BY N

这句SQL就能得到你想要的集合,不用编程

[此贴子已经被作者于2007-10-3 13:43:02编辑过]

楼上的兄弟：我要的是一次得出某一时间段的分别A、B、C的和，你的sql语句是求H列的总和，请兄弟在帮忙改改。

rq N H
2007-01-02 A 15
2007-02-02 A 100
2007-02-15 B 110
2007-02-18 C 12
2007-02-19 B 150
2007-02-20 C 100
原始是这样.
那你要的结果是怎么样呢?

我要的计算结果应该是：
A=115
B=260
C=112

在sql查询分析器执行
[CODE]if object_id('t') is not null
drop table t
go
create table t(
rq datetime,
N char(1),
H int
)
insert t select '2007-01-02','A',15
union all select '2007-02-02','A',100
union all select '2007-02-15','B',110
union all select '2007-02-18','C',12
union all select '2007-02-19','B',150
union all select '2007-02-20','C',100
go[/CODE]


在visual basic里编写代码.
[CODE]Private Sub Command1_Click()
Dim Con As New ADODB.Connection
Dim Rst As New ADODB.Recordset

Con.Open "Provider=SQLOLEDB;Data Source=(local);Initial Catalog=myData;User ID=sa;Password=admin;"

Rst.CursorLocation = adUseClient
Rst.Open "select N,sum(H) AS H from t group by N", Con, adOpenKeyset, adLockReadOnly, adCmdText
While Not Rst.EOF
'在调试窗口输出
Debug.Print Rst.Fields("N").Value & "----" & Rst.Fields("H").Value
Rst.MoveNext
Wend

Rst.Close
Con.Close

Set Rst = Nothing
Set Con = Nothing
End Sub[/CODE]

[此贴子已经被作者于2007-10-3 22:16:10编辑过]

[QUOTE]楼上的兄弟：我要的是一次得出某一时间段的分别A、B、C的和，你的sql语句是求H列的总和，请兄弟在帮忙改改。[/QUOTE]
你都没试,看来你要恶补SQL语句

数据库


语句


结果

楼上的兄弟..
我已经问你你想要的结果是怎么样..
你是说
A=115
B=260
C=112
..我当然是写成这个..

如果你不是这个意思.
那请你将你想要的完整结果写出来.