要这样才行
Dim d As Date = New Date(2000, 1, 1)
Tables("订单").Filter="[日期] >= #" & d & "# and [日期] < #" & d.AddYears(1) & "#"