两个编号的近钮代码:
Dim dt As Table = Tables("申请表")
For i As integer = 0 to dt.rows.count -1
if i = 0 Then
dt.Rows(i)("乡镇序号") = 1
Else
if dt.Rows(i)("乡名") = dt.Rows(i-1)("乡名") Then
dt.Rows(i)("乡镇序号") = dt.Rows(i-1)("乡镇序号")
Else
dt.Rows(i)("乡镇序号") = dt.Rows(i-1)("乡镇序号")+1
End If
End If
Next
Dim str As String
For Each dr As DataRow In DataTables("申请表").DataRows
str = "[乡名] = '" & dr("乡名") & "'And [村名] = '" & dr("村名") & "' And [组别] = '" & dr("组别") & "'"
str = str & " And [单位(个人)] = '" & dr("单位(个人)") & "' And [_Identify] < " & dr("_Identify")
dr("宗地序号") = Format(Tables("申请表").Compute("Count(乡名)",str)+1,"00")
Next
[此贴子已经被作者于2009-10-24 22:57:28编辑过]