|
Private Sub Command18_Click()
On Error GoTo aa
Dim k3 As String
k3 = Me.subform.Form.RecordSource
Me.subform.SourceObject = ""
Me.subform.SourceObject = "frm返修单查询汇总-子窗体"
'MsgBox k3
Me.subform.Form.RecordSource = k3
'K3是一个窗体的记录源变量.且是SQL语句.
bb:
Exit Sub
aa:
Resume bb
End Sub
'K3是一个窗体的记录源变量.且是SQL语句.
如:SELECT dbo.tbl返修明细单.* FROM dbo.tbl返修明细单 where 故障类别 like'%元材料%'
现在我想把此数据源作为一临时表,在此基础上再查询.即汇总.
SELECT 产品型号, COUNT(产品编号) AS 维修数量
FROM K3
GROUP BY 产品型号
但是这样不行.请教我应该怎么做.谢谢!! |
|