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

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 & ""

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 & ""

那就是没有符合条件的数据，自己检查条件和数据