Foxtable(狐表)用户栏目专家坐堂 → 筛选出错


  共有1815人关注过本帖树形打印复制链接

主题:筛选出错

帅哥哟,离线,有人找我吗?
有点蓝
  1楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:超级版主 帖子:110629 积分:563047 威望:0 精华:9 注册:2015/6/24 9:21:00
  发帖心情 Post By:2018/6/26 23:02:00 [显示全部帖子]

1

''统计职务
With e.Form.Controls("cmbPos")
    If .Value IsNot Nothing Then
        If Filter >"" Then
            Filter = Filter & " And "
        End If
        Filter = Filter & "retiredPost in ('" & .Value.replace(",","','") & "')"
    End If
End With

2、增加一个组合框选择咯
''统计党龄
With e.Form.Controls("cmbPartySta")
    If .Value IsNot Nothing Then
        If Filter > "" Then
            Filter = Filter & " And "
        End If
        Filter = Filter & " partyStanding " & e.Form.Controls("大于,小于,等于三个选项组合框").text & " '" & .Value & "'"
    End If
End With


 回到顶部