设计一个函数即可
Function hb(bm, hm, jg)
Dim dbs As Database '定义引用数据库的变量。
Dim rst As DAO.Recordset '定义引用记录集的变量。
Dim sql1 As String
'On Error GoTo err1
'使用DAO操作打开明细记录集
Set dbs = CurrentDb()
If Nz(jg) = "" Then
sql1 = "Select * from " & bm & " where 制令号码='" & hm & "' and 加工 Is Null"
Else
sql1 = "Select * from " & bm & " where 制令号码='" & hm & "' and 加工='" & Nz(jg) & "'"
End If
Set rst = dbs.OpenRecordset(sql1) '设置记录集
s = ""
While Not rst.EOF
s = s & rst("A") & "+"
If Not rst.EOF Then rst.MoveNext
Wend
hb = Mid(s, 1, Len(s) - 1)
End Function
然后再设计一个查询,调用该函数即可
SELECT 表1.制令号码, 表1.加工, hb("表1",[制令号码],nz([加工])) AS 合并
FROM 表1
GROUP BY 表1.制令号码, 表1.加工, hb("表1",[制令号码],nz([加工]));
点击下载此附件