Select Case MainTable.Name
Case "镇级表"
MainTable.DataTable.DataRows.Clear
Dim arys As List(Of String()) = DataTables("出生").GetUniqueValues("", "单位名称", "组名称")
For Each ary As String() In arys
Dim r As Row = MainTable.AddNew
r("单位") = ary(0)
r("组名称") = ary(1)
Dim filter As String = "单位 = '" & ary(0) & "' ' & "' And #2011-01-01#<= 子女出生日期 And 子女出生日期 <= #2011-12-31#"
r("出生_总数") = DataTables("出生").Compute("Count(_Identify)", filter)
r("出生_政策内_一孩") = DataTables("出生").Compute("Count(_Identify)", filter & " And 子女政策属性 = '政策内' And 子女孩次 = 1")
r("出生_政策内_二孩") = DataTables("出生").Compute("Count(_Identify)", filter & " And 子女政策属性 = '政策内' And 子女孩次 = 2")
r("出生_政策内_多孩") = DataTables("出生").Compute("Count(_Identify)", filter & " And 子女政策属性 = '政策内' And 子女孩次 > 2 ")
r("出生_政策外_一孩") = DataTables("出生").Compute("Count(_Identify)", filter & " And 子女政策属性 = '政策外' And 子女孩次 = 1")
r("出生_政策外_二孩") = DataTables("出生").Compute("Count(_Identify)", filter & " And 子女政策属性 = '政策外' And 子女孩次 = 2")
r("出生_政策外_多孩") = DataTables("出生").Compute("Count(_Identify)", filter & " And 子女政策属性 = '政策外' And 子女孩次 > 2")
Next
End Select
帮忙修改下开头,生成镇级表,统计所有村的数据,谢谢
[此贴子已经被作者于2012-11-24 18:57:26编辑过]