技術(shù) 點
- 技術(shù)
- 點
- V幣
- 點
- 積分
- 22799
|
2#
發(fā)表于 2015-12-30 14:14:16
|
只看該作者
'執(zhí)行代碼前先引用Microsoft ActiveX Data Object 2.8 Library
- Sub test()
- Dim rst1 As New ADODB.Recordset
- Dim rst2 As New ADODB.Recordset
- Dim rst3 As New ADODB.Recordset
- Dim i As Long, j As Long, k As Long
- Dim Arr
- rst1.Open "select distinct 班級 from 測試數(shù)據(jù)", CurrentProject.Connection, adOpenKeyset, adLockOptimistic
- Do Until rst1.EOF
- rst2.Open "select 姓名 from 測試數(shù)據(jù) where 班級='" & rst1(0) & "'", CurrentProject.Connection, adOpenKeyset, adLockOptimistic
- rst3.Open "結(jié)果表", CurrentProject.Connection, adOpenKeyset, adLockOptimistic
- Arr = rst2.GetRows()
- For i = 0 To UBound(Arr, 2)
- For j = i + 1 To UBound(Arr, 2)
- For k = j + 1 To UBound(Arr, 2)
- rst3.AddNew
- rst3(0) = Arr(0, i)
- rst3(1) = Arr(0, j)
- rst3(2) = Arr(0, k)
- rst3(3) = rst1(0)
- Next
- Next
- Next
- rst3.UpdateBatch
- rst3.Close
- rst2.Close
- rst1.MoveNext
- Loop
- rst1.Close
- End Sub
復(fù)制代碼
附上2007版本附件,如果你的是2003的話,請新建一個模塊,把上述代碼貼上,在VBE界面下,按下F5執(zhí)行即可。
|
本帖子中包含更多資源
您需要 登錄 才可以下載或查看,沒有帳號?注冊
x
|