估计是这段代码写错了
Select Case e.Node.Level Case 0 Filter =Filter1 And "Year(收款日期) = " & Value(0) Case 1 Filter =Filter1 And "Year(收款日期) = " & Value(0) & " And Month(收款日期) = " & Value(1) Case 2 Filter =Filter1 And "Year(收款日期) = " & Value(0) & " And Month(收款日期) = " & Value(1)& " And Day(收款日期) = '" & Value(2) & "'" End Select
改为
Select Case e.Node.Level Case 0 Filter =Filter1 & " And Year(收款日期) = " & Value(0) Case 1 Filter =Filter1 & " And Year(收款日期) = " & Value(0) & " And Month(收款日期) = " & Value(1) Case 2 Filter =Filter1 & " And Year(收款日期) = " & Value(0) & " And Month(收款日期) = " & Value(1) & " And Day(收款日期) = '" & Value(2) & "'" End Select
|