--
dim str as string = ""
For Each r As Row In Tables("表A").rows
Dim dr As DataRow= DataTables("表B").find("年度=\'" & r("年度") & "\' and 地市名称=\'" & r("地市名称") & "\' and 面试室=\'" & r("面试室") & "\'")
If dr Is Nothing Then
msgbox("没有同样的数据")
Else
If r("加权系数") <> r("加权系数")
str = str & "," & r.index
End If
End If
Next
if str > "" then
e.form.controls("某文本框").text = "数据不一致,行号" & str
else
e.form.controls("某文本框").text = "正确"
end if
[此贴子已经被作者于2020/1/19 14:41:03编辑过]