呵呵,统计行数,不需要用Select,太重量级了,用Compute:
Dim a As Integer = Date.Today.YearDim n As integer = DataTables("表A").Compute(“Count([_Identify])”, "日期>= #1/1/" & a & "# and 日期 <= #12/31/" & a & "#")