Filter1 = filter & " and 日期 >= #" & dt3 & "# And 日期 <= #" & dt4 & "#"
改成
Filter1 = filter & " and 日期 >= #" & dt3 & "# And 日期 < #" & dt3.AddMonths(1) & "#"