|
1.新建模块一个
Public Function Getstring(rsField As Integer) As String
Dim rs As New ADODB.Recordset
Dim cnn As New ADODB.Connection
Dim strSql As String
Set cnn = CurrentProject.Connection
strSql = "select * from 表1 where 字段1=" & rsField & ""
rs.Open strSql, cnn, adOpenKeyset, adLockOptimistic
Do While Not rs.EOF
Getstring = Getstring & rs.Fields("字段2")
rs.MoveNext
Loop
rs.Close
Set rs = Nothing
Set cnn = Nothing
End Function
2.再建查询一个
SELECT 表1.字段1, Getstring([字段1]) AS 字段2
FROM 表1
GROUP BY 表1.字段1, Getstring([字段1]);
[ 本帖最后由 dddddd 于 2007-10-11 22:13 编辑 ] |
|