主题：[求助]筛选条件如何设置

cmd.CommandText = "Select Count(*) From {表1} where 代码 = 'XY' and ID = '" &  xtid & "' and 登记人 = '" & nm & "' " & iif(Filter > "", " and "  & Filter, "")

跪谢！！！！！！

不应该是你那句代码的问题吧？弹出看看值是什么

 

msgbox(cmd.CommandText)

老师，我查出来是下面的这段代码，但不知道问题出在哪里，麻烦您看看

msgbox(cmd.CommandText) ‘显示看看最终的sql是怎么样的

cmd.CommandText = "Select * From (Select Row_Number() Over(Order by 事件日期 desc ) As RowNum, 编号,项目名称,项目编号,供应商,供应商编号,字母,单据号1 as 单据号,事件日期 as 日期,事件人,事件人编号,金额合计 as 明细合计,类别,实际金额,流程状态 as 状态,登记人职务,登记人,登记日期 From{全表} where 代码 = '" & dm & "' and ID = '" &  xtid & "' and 登记人 = '" & nm & "' And 项目名称 = '" & xmmc & "'" & iif(Filter > "", " and "  & Filter, "")) As a Where RowNum >= " & StartRow & " And RowNum <= " & EndRow & ""

老师，不行啊，加了引号之后出现报错了 cmd.CommandText = "Select * From (Select Row_Number() Over(Order by 事件日期 desc ) As RowNum, 编号,项目名称,项目编号,供应商,供应商编号,字母,单据号1 as 单据号,事件日期 as 日期,事件人,事件人编号,金额合计 as 明细合计,类别,实际金额,流程状态 as 状态,登记人职务,登记人,登记日期 From{全表} where 代码 = '" & dm & "' and ID = '" &  xtid & "' and 登记人 = '" & nm & "' And 项目名称 = '" & xmmc & "'" & iif(Filter > "", " and "  & Filter, "")) As a Where RowNum >= " & StartRow & " And RowNum <= " & EndRow & "" 此主题相关图片如下：应为语句结束.jpg

cmd.CommandText = "Select * From (Select Row_Number() Over(Order by 事件日期 desc ) As RowNum, 编号,项目名称,项目编号,供应商,供应商编号,字母,单据号1 as 单据号,事件日期 as 日期,事件人,事件人编号,金额合计 as 明细合计,类别,实际金额,流程状态 as 状态,登记人职务,登记人,登记日期 From{全表} where 代码 = '" & dm & "' and ID = '" &  xtid & "' and 登记人 = '" & nm & "' And 项目名称 = '" & xmmc & "'" & iif(Filter > "", " and "  & Filter, "")) As a Where RowNum >= " & StartRow & " And RowNum <= " & EndRow & ""