以文本方式查看主题

-  Foxtable(狐表)  (http://www.foxtable.com/bbs/index.asp)
--  专家坐堂  (http://www.foxtable.com/bbs/list.asp?boardid=2)
----  [求助]  (http://www.foxtable.com/bbs/dispbbs.asp?boardid=2&id=32471)
--  作者：hsinly
--  发布时间：2013/5/2 21:47:00
--  [求助]
做好了筛选窗口，，如何把筛选出来的结果，，进行弹窗计数统计呢。。。求代码
--  作者：hsinly
--  发布时间：2013/5/2 21:48:00
--  
End With
With e.Form.Controls("cmbgc")
    If .Value IsNot Nothing Then
        If Filter > "" Then
            Filter = Filter & " And "
        End If
        Filter = Filter & "购车否 = \'" & .Value & "\'"
    End If
End With
If e.Form.Controls("rdos").Checked = True \' 如果付款状态选择了"已付"
    If Filter >"" Then
        Filter = Filter & " And "
    End If
    Filter = Filter & "是否模特 = True"
End If
If e.Form.Controls("rdof").Checked = True \' 如果付款状态选择了"未付"
    If Filter >"" Then
        Filter = Filter & " And "
    End If
    Filter = Filter & "是否模特 = False Or 是否模特 Is Null"
End If
If e.Form.Controls("rdotz").Checked = True \' 如果付款状态选择了"已付"
    If Filter >"" Then
        Filter = Filter & " And "
    End If
    Filter = Filter & "是否体验团 = True"
End If
If e.Form.Controls("rdotzf").Checked = True \' 如果付款状态选择了"未付"
    If Filter >"" Then
        Filter = Filter & " And "
    End If
    Filter = Filter & "是否体验团 = False Or 是否体验团 Is Null"
End If
If Filter > "" Then
    Tables("读者数据库").Filter = Filter
End If