主题：交叉统计的汇总数据不对

谢谢，终于搞好了，把数据一个个对了下

这段命令能在表达式列中吗？

那只能通过命令的方式执行吗？

Dim Filter As String
With e.Form.Controls("cmbProduct")
    If .Value IsNot Nothing Then
        Filter = " 管理部 = '" & .Value & "'"
    End If
End With
With e.Form.Controls("cmbCustomer")
    If .Value IsNot Nothing Then
        If Filter > "" Then
            Filter = Filter & " And "
        End If
        Filter = Filter & " 类别 = '" & .Value & "'"
    End If
End With
With e.Form.Controls("cmbEmployee")
    If .Value IsNot Nothing Then
        If Filter >"" Then
            Filter = Filter & " And "
        End If
        Filter = Filter & " 经办人 = '" & .Value & "'"
    End If
End With
With e.Form.Controls("StartDate")
    If .Value IsNot Nothing Then
        If Filter >"" Then
            Filter = Filter & " And "
        End If
        Filter = Filter & " 登记时间 >= #" & .Value & "#"
    End If
End With
With e.Form.Controls("EndDate")
    If .Value IsNot Nothing Then
        If Filter >"" Then
            Filter = Filter & " And "
        End If
        Filter = Filter & " 登记时间 <= #" & .Value & "#"
    End If
End With
If Filter > "" Then
    Tables("管场异常登记").Filter = Filter
End If

写了这段筛选的代码，怎么前面的都不执行，只有登记时间的可以筛选，哪里出问题了

是一个筛选窗口，怎么上传啊

搞好了，请问筛选出来的表怎么调用呢？

筛选后的表名是怎么定义呢？