如筛选本月的订单:
Dim y As Integer = Date.Today.YearDim m As Integer = Date.Today.MonthDim dt1 As New Date(y, m, 1)Dim Filter As StringFilter = "日期 >= #" & dt1 & "# And 日期 < #" & dt1.addmonths(1) & "#"Tables("订单").Filter = Filter