对表进行筛选即可,如
Dim d As Date = New Date(Date.Today, 1, 1)
Tables("表A").Filter = "日期 >= #" & d & "# and 日期 < #" & d.addMonths(1) & "#"